SQL Database Concepts Question:
Please explain GO Command in SQL Server?
Answer:
GO command indicates the end of the SQL statements. It is used when there are multiple statements to be executed but sent as a batch.
Example:
SELECT * FROM table1 INNER JOIN table2 ON table1.c1 = table2.c1 WHERE table1.c1 > 10 ORDER BY table1.c1
GO
Example:
SELECT * FROM table1 INNER JOIN table2 ON table1.c1 = table2.c1 WHERE table1.c1 > 10 ORDER BY table1.c1
GO
| Previous Question | Next Question |
| Do you know what is difference between stored procedure and user defined function? | Do you know what are ACID properties of Transaction? |