Change TSQL batch separator GO

GO is not a T-SQL statement instead it’s a command to separate T-SQL statements from one another into different batches, recognized by SQLCMD, OSQL and SSMS. To change TSQL batch separator “GO” do the following.

Connect to SSMS – Click Options – This will open the Options dialogue box. In options dialogue box, select Query Execution – SQL Server. On the right side window, change the batch separator under the label Batch Separator and click OK as shown below.

1_change tsql batch separator go

   

The new batch separator can be used as shown below. Using GO will result in an error.

2_change tsql batch separator go

 

Like us on FaceBook Join the fastest growing SQL Server group on FaceBook

   

Leave a Reply

Your email address will not be published.