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

Question

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

User · Answer

The GO command isn t a Transact-SQL statement  but a special command recognized by several MS utilities including SQL Server Management Studio code editor   The GO command is used to group SQL commands into batches which are sent to the server together   The commands included in the batch  that is  the set of commands since the last GO command or the start of the session  must be logically consistent   For example  you can t define a variable in one batch and then use it in another since the scope of the variable is limited to the batch in which it s defined   For more information  see http   msdn microsoft com en-us library ms188037 aspx

User · Answer

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

User · Answer

Just to add to the existing answers  when you are creating views you must separate these commands into batches using go  otherwise you will get the error  CREATE VIEW  must be the only statement in the batch  So  for example  you won t be able to execute the following sql script without go  create view MyView1 as select Id Name from table1 go create view MyView2 as select Id Name from table1 go  select   from MyView1 select   from MyView2

User · Answer

Go means  whatever SQL statements are written before it and after any earlier GO  will go to SQL server for processing   Select   from employees  GO    -- GO 1  update employees set empID 21 where empCode 123  GO    -- GO 2   In the above example  statements before GO 1 will go to sql sever in a batch and then any other statements before GO 2 will go to sql server in another batch  So as we see it has separated batches

User · Answer

Since Management Studio 2005 it seems that you can use GO with an int parameter  like   INSERT INTO mytable DEFAULT VALUES GO 10   The above will insert 10 rows into mytable  Generally speaking  GO will execute the related sql commands n times

User · Answer

GO is not a SQL keyword   It s a batch separator used by client tools  like SSMS  to break the entire script up into batches  Answered before several times    example 1

User · Answer

Use herDatabase GO      Code says to execute the instructions above the GO marker  My default database is myDatabase  so instead of using myDatabase GO and makes current query to use herDatabase

[sql-server] What is the use of GO in SQL Server Management Studio & Transact SQL?

Examples related to sql-server

Examples related to tsql

Examples related to ssms