SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 360 Page Views: 

What is the function of GO command in SQL SERVER?



Posted By: Avi Date: 1 October 2010 12:15:08 PM
 Answer:

To mark the end of the T-SQL batch statements GO command is used. Its should be kept in mind that GO is not a T-SQL statement it’s a command recognised by osql and sqlcmd utilities. GO command is interpreted as a signal that the T-SQL batch statements are done and should be send to SQL Server instance for execution.


Posted By: avibtech


Date: 1 October 2010 12:15:08 PM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image WDGbrI
Related Questions
SQL Server : What are DDL statements? Name some DDL Statements?

What are DDL statements? Name some DDL Statements?

DDL statements mean Data Definition Language statements. This the vocabulary used to define the data....
Category: SQL Server Date: 10/1/2010 11:18:07 AM
SQL Server : Does the order of columns matter while creating a table? i.e which coulms should come first and which last according to constraints and values?
SQL Server : Having the following table:- 
sno          val1
1              7.5
2              8
3              9.5
4              11
.
.
.
N              val
Write the code to update the table where the difference in the column "val1" is computed i.e. (val1[2]-val1[1

Having the following table:- sno val1 1 7.5 2 8 3 9....

Code Required is:- update cal set diff_val = 0 where ID = (select min(sno) from cal) Update cal ....
Category: SQL Server Date: 10/1/2010 11:16:07 AM
SQL Server : Differentiate between Function and Stored Procedure?

Differentiate between Function and Stored Procedure?

1. Function returns a value but it is not necessary that stored procedure return a value. 2. Functio....
Category: SQL Server Date: 10/1/2010 11:15:07 AM
SQL Server : What is the purpose of the locks in SQL Server?

What is the purpose of the locks in SQL Server?

Category: SQL Server Date: 10/1/2010 11:12:07 AM