Link to home
Start Free TrialLog in
Avatar of hello_2004
hello_2004

asked on

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?

ASKER CERTIFIED SOLUTION
Avatar of Hilaire
Hilaire
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial