MSSQL Invalid compare -wrap text and 2 GO added which make invalid the script

[topiland]

In both database the script is same:

select DSZAM=case when UZEMKOD='C' then 'K' else 'C' end + convert(varchar(6), @sorszam+n), DSZAMNEV=case when UZEMKOD='C' then 'K' else 'C' end + convert(varchar(6), @sorszam+n), 

And it get wrapped and 2 GO added, and even the wrap is not in same position
the error in sql view and in migration scrip to, which made them bad:

select DSZAM=case when UZEMKOD='C' then 'K' else 'C' end + convert(varcha

GO
GO

r(6), @sorszam+n), DSZAMNEV=case when UZEMKOD='C' then 'K' else 'C' end + convert(varchar(6), @sorszam+n),

select DSZAM=case when UZEMKOD='C' then 'K' else 'C' end + convert(varc

GO
GO

har(6), @sorszam+n), DSZAMNEV=case when UZEMKOD='C' then 'K' else 'C' end + convert(varchar(6), @sorszam+n),

[drebrez]

Hi @topiland,

thanks for submitting the issue.

Indeed it's quite strange, would be useful if I can reproduce it, is it a store procedure?

Could you please try the query used to retrieve the stored procedures and see if those GO are returned by the SQL server or the stored procedure is somehow splitted in multiple rows?

SELECT name as 'Name',
       SCHEMA_NAME(schema_id) as 'Schema',
       OBJECT_DEFINITION(object_id) as 'Definition'
FROM sys.objects
WHERE type IN ('P', 'PC') AND
      NULLIF(OBJECT_DEFINITION(object_id), '') IS NOT NULL AND
      SCHEMA_NAME(schema_id) <> 'sys'

Best regards