Begin--end and go

GO is like the end of a script.

You could has multiple CREATE TABLE statements, separated by GO. It's a-a-isolating one part of the script from another, but submitting it all in one block.

BEGIN and END is just like {and} in c/++/#, Java, etc.

They bound a logical block of code. I tend to use BEGIN and end at the start and end of a stored procedure, but it's not strictly necessary there. Where it is necessary are for loops, and IF statements, etc, where you need more then one step ...

IF EXISTS (SELECT * FromMy_tableWHERE ID = @id begin insert  into Log select @id,  ' deleted '  delete my_table where= @idend 
 
 
 
 
 http://stackoverflow.com/questions/1180279/ When-do-i-need-to-use-begin-end-blocks-and-the-go-keyword-in-sql-server 
        

Begin--end and go