What is the use of GO in SQL Server Management Studio & Transact SQL?

sql-server tsql ssms
tvanfosson picture tvanfosson · Feb 19, 2010 · Viewed 289.8k times · Source

SQL Server Management Studio always inserts a GO command when I create a query using the right click "Script As" menu. Why? What does GO actually do?

Answer

SQLMenace picture SQLMenace · Feb 19, 2010

It is a batch terminator, you can however change it to whatever you want alt text

Related questions

Recover unsaved SQL query scripts

How to recover the unsaved scripts if the SSMS crashes / unsaved tab gets accidentally closed?

Read More
How to view the stored procedure code in SQL Server Management Studio

I am new to SQL Server. I am logged into my database through SQL Server Management Studio. I have a list of stored procedures. How do I view the stored procedure code? Right clicking on the stored procedure does not …

Read More
What is the T-SQL syntax to connect to another SQL Server?

If I need to copy a stored procedure (SP) from one SQL Server to another I right click on the SP in SSMS and select Script Stored Procedure as > CREATE to > New Query Editor Window. I then change …

Read More