Effect of not specifyin GO in SQL Server stored procedure

Question

I would like to know whether my stored procedure will get impacted without specifying Go

Here is the code flow:

Create or replace store_proc1
As
Begin
   While loop
    {SQL statements repeating itself until source table record count is 0}
   End

"Go"

Here I have missed Go at the end of my stored procedure.. Will it impact the performance?

You might want to take a look at this: http://stackoverflow.com/questions/2668529/t-sql-go-statement — shree.pat18, Mar 28 '14 at 10:14

score 3 · Answer 1 · answered Mar 28 '14 at 10:27

3

GO is not a SQL statement - it's a delimiter used only in SQL Server Management Studio.

So no, omitting GO will NOT in any way affect your stored procedure's ability to run, nor it performance.

answered Mar 28 '14 at 10:27

marc_s

1 Answers1