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

Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Leave a Reply

Your email address will not be published. Required fields are marked *