#go usage in sql server

GO is required at the specified point if you modify an already-existing stored procedure, if you have an execution statement open in the same query window, and if you intend to execute both statements simultaneously. If not, the execution statement will b

GO is interpreted by SQL Server utilities as a signal to deliver the current batch of Transact-SQL statements to a SQL Server instance. All statements entered since the last GO, or since the beginning of the ad hoc session or script if this is the first GO, make up the current batch of statements. To put it simply, SQL commands are grouped into batches and delivered to the server collectively…