T-SQL keywords go

ZT
Record
Transact-SQL reference

Go

Use a signal to notify Microsoft SQL server of the completion of a batch of transact-SQL statements.

Syntax

Go

Note

Go is not a Transact-SQL statement.OsqlAndISQLUtility and SQL Server Query analyzer recognition commands.

The SQL Server utility interprets go as a signal that the current Transact-SQL batch processing statement should be sent to SQL Server. The current batch processing statement is all the statements entered after the previous go command. If it is the first go command, it is all the statements from the beginning of a special session or script to the beginning of this go command. SQL query analyzer andOsqlAndISQLThe command prompts the utility to execute the go command in different ways. For more information, see osql utility, iSQL utility, and SQL query analyzer.

The go command and the transact-SQL statement cannot be on the same line. However, the go command line can contain comments.

You must follow the batch processing rules. For example, after the first statement in the batch processing, any stored procedure must contain the execute keyword. The scope of local (User-Defined) variables is limited to one batch and cannot be referenced after the go command.

Use pubsgodeclare @ mymsg varchar (50) Select @ mymsg = 'hello, world. 'Go -- @ mymsg is not valid after this go ends the batch. -- yields an error because @ mymsg not declared in this batch. print @ mymsggoselect @ version; -- yields an error: Must be exec sp_who if not first statement in -- batch. sp_whogo
 

SQL Server ApplicationProgramMultiple Transact-SQL statements can be sent to SQL Server for execution as a batch. The statements in this batch are compiled into an execution plan. The programmer executes a specific statement in the SQL Server utility or generates a Transact-SQL statement script to run in the SQL Server utility, and uses go to identify the end of batch processing.

If an application based on DB-library, ODBC, or ole db APIs tries to execute the go command, it will receive a syntax error. SQL Server utility never sends go commands to the server.

Permission

Go is a utility command without permissions. It can be executed by any user.

Example

The following example creates two batches. The first batch contains only one usePubsStatement, used to set the database context. The remaining statement uses a local variable, so all local variable declarations must be in a batch. This can be done by using the go command only after the last statement that references this variable.

  Use pubsgodeclare @ nmbrauthors intselect @ nmbrauthors = count (*) from authorsprint 'the number of authors as of '+ Cast (getdate () as char (20 )) + 'is' + Cast (@ nmbrauthors as char (10) Go