Go statement in SQl server stored procedures

Stored procedure written in sql server 2000 and called from vb6 program.

What is the difference between stored procedure that contains GO as the last statement & the one that is written without GO statement?

Does that mean : if I call 1st stored procedure through my application that doesn't have GO at the end & then call 2nd stored procedure that doesn't have GO either & call the 3rd stored procedure that has GO statement at the end. Will it work as a transaction? I mean if an error occured in 2nd stored procedure ... then will the results of 1st stored procedure be also rolled back b'cos there was no GO statement in first two procedures?

Who is Participating?
HilaireConnect With a Mentor Commented:
You CAN'T have a GO statement inside a stored procedure

the GO at the end of a create statement is just for SQL Server to know that the procedure ends here,
and separate the "create procedure " statements from one another when you have several in the same script.

create proc sp_dummy  as
select 1

-- display sp code --> you won't see any go
sp_helptext sp_dummy

drop proc sp_dummy
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.