|
Posted by jim_geissman on 02/14/07 21:54
I'm not the expert that Erland is, but I think I know.
GO and semicolon both serve to separate statements. But GO also
separates batches.
If you make 4 statements into one batch like this --
statement1; statement2; statement3; statement4 GO
....and statement4 fails with an error, the affected objects are
restored to the way they were before statement1.
If you make them 4 separate batches like this --
statement1 GO statement2 GO statement3 GO statement4 GO
.... and statement4 fails with an error, the objects are restored to
the way they were after statement 3.
Jim
Navigation:
[Reply to this message]
|