Syntax issue with SQL Server GO command [duplicate]

Question

I am using C# to add extended properties to the tables in my database. When I use a SQL editor, this code works, as each statement is on a new line. However, when creating the command as a string in C#, I get 'Incorrect syntax near GO' twice in the same error message. How can I write this out so that c# executes it on seperate lines or in the correct syntax?

USE UserList; 
GO EXEC sys.sp_addextendedproperty 
@name = N'Description', 
@value=N'some text', 
@level0type=N'SCHEMA', @level0name=N'dbo', 
@level1type=N'TABLE', 
@level1name=N'table_name'
GO

GO is a hint for SQL Management Studio, see stackoverflow.com/questions/40814/… and others — Alex K.
– Alex K., Commented Feb 12, 2014 at 16:35
Also, using @ before your string literal lets you use multiline queries without adding special characters. — Tarec
– Tarec, Commented Feb 12, 2014 at 16:37
Took out the GO and now it works flawlessly, thanks guys. Make an answer and I'll accept it. — barnacle.m
– barnacle.m, Commented Feb 12, 2014 at 16:48

M.Ali · Accepted Answer · 2014-02-12 17:26:03Z

1

USE UserList; 
GO         --<-- Go key word should be on it own in a line nothing before or after 

EXEC sys.sp_addextendedproperty 
@name = N'Description', 
@value=N'some text', 
@level0type=N'SCHEMA', @level0name=N'dbo', 
@level1type=N'TABLE', 
@level1name=N'table_name'
GO

answered Feb 12, 2014 at 17:26

M.Ali

69.9k17 gold badges110 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

barnacle.m Over a year ago

This shows you hardly read my question or following comments.

Collectives™ on Stack Overflow

Syntax issue with SQL Server GO command [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related