What does the 'GO' command do???

[rmahawaii]

Hello All, I just want to know what does the 'GO' command do in a stored procedure? I noticed there is a difference when I put it in or when I left it out. It will usually cause compiler error when i put it in. Can anyone please let me know? Thanks in advance.

 

[administratorx]

OSQL, ISQL and query analyzer all use it to signal the end of a batch. But it is not a TSQL command.

 

[tlbroadbent]

When compiling a stored procedure or view, GO marks the end of a batch or effectively the end of the SP or view. SQL BOL contains more information about GO.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_ga-gz_8hf3.asp

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[sqlnerd]

Like the other folks have replied, the GO ends a batch. But, you mentioned that it causes compiler error. That is not correct. It means that you have put GO in a wrong place. When a batch is marked by a GO, information such as a local variable will be limited only to that batch and if you refer to those in any other batch in the stored proc, then error will occur. I think this is the reason why you get compiler error.

SQLnerd

 

[rmahawaii]

Thanks for all of your explanations folks. I now understand my problem clearly. Thanks