I tried to compose a string to execute in SQL Server:
DECLARE @sql varchar(4000) =
'EXEC sys.sp_addextendedproperty @name=N''MS_Description'', @value=N''' + 'описание' + ''', @level0type=N''SCHEMA'',@level0name=N''' + 'rudata_r2' + ''', @level1type=N''TABLE'',@level1name=N''' + 'Subscriptions' + ''', @level2type=N''COLUMN'',@level2name=N''' + 'id' + '''' + char(13) + char(10) + 'GO'
EXEC(@sql)
but I got an error:
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'GO'
Where is my mistake?