Collections:
GO - Sending a Statement Batch from "sqlcmd" in SQL Server
How To Use GO Command in "sqlcmd" in SQL Server?
✍: FYIcenter.com
"sqlcmd" is a command line client application to run Transact-SQL statements on a target SQL Server.
When "sqlcmd" is started and connected to a SQL Server, it will start a new batch and prompt you to enter the first statement of the batch. You can enter one or more statements in one or more lines to form a Transact-SQL statement batch.
To end a batch of statements and send it to the SQL Server for execution, you need to enter the GO command. The following "sqlcmd" tutorial session sends two batches to the SQL Server:
C:\>sqlcmd -S localhost\sqlexpress -U sa -P FYIcenter 1> SELECT getdate(); 2> SELECT getdates(); 3> SELECT getdate(); 4> GO Msg 195, Level 15, State 10, Line 2 'getdates' is not a recognized built-in function name. 1> SELECT getdate(); 2> SELECT getdate(); 3> SELECT getdate(); 4> GO ----------------------- 2007-05-19 22:55:07.233 (1 rows affected) ----------------------- 2007-05-19 22:55:07.233 (1 rows affected) ----------------------- 2007-05-19 22:55:07.233 (1 rows affected) 1>QUIT C:\
⇒ Downloading and Installing SQL Server 2005 Books Online in SQL Server
⇐ Running Queries with 'sqlcmd' Tool in SQL Server
⇑ Downloading and Installing SQL Server 2005 Express Edition
2016-12-04, 3573🔥, 0💬
Popular Posts:
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...