anthony.green (12/4/2012)
GO is a batch sperator.So you could say
Do Something
Do Something Else
Do Something More
GO
Do Something Even More
Do Something Better Than Before
GO
And it would execute the first three things in one batch, and the last two things in another batch.
Without the GO's it would execute all 5 things in one batch
Thanks antony for the reply but since i am relatively new to SQL Server, i was wondering in what scenario would we like the above mention thing to happen. I mean to say there is no conditional break and my objective is to excute all the 5 statement, so to me executing them one after another in sequence matter, why should i used GO.