| title | Start the sqlcmd Utility | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/14/2017 | |
| ms.prod | sql-server-2016 | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | article | |
| ms.assetid | 00d57437-7a29-4da1-b639-ee990db055fb | |
| caps.latest.revision | 41 | |
| author | JennieHubbard | |
| ms.author | jhubbard | |
| manager | jhubbard |
The sqlcmd Utility lets you enter [!INCLUDEtsql] statements, system procedures, and script files at the command prompt, in Query Editor in SQLCMD mode, in a Windows script file or in an operating system (Cmd.exe) job step of a [!INCLUDEssNoVersion] Agent job.
Note
Windows Authentication is the default authentication mode for sqlcmd. To use [!INCLUDEssNoVersion] Authentication, you must specify a user name and password by using the -U and -P options.
Note
By default, [!INCLUDEssExpress] installs as the named instance sqlexpress.
-
On the Start menu click Run. In the Open box type cmd, and then click OK to open a Command Prompt window. (If you have not connected to this instance of the [!INCLUDEssDEnoversion] before, you may have to configure [!INCLUDEssNoVersion] to accept connections.)
-
At the command prompt, type sqlcmd.
-
Press ENTER.
You now have a trusted connection to the default instance of [!INCLUDEssNoVersion] that is running on your computer.
1> is the sqlcmd prompt that specifies the line number. Each time you press ENTER, the number increases by one.
-
To end the sqlcmd session, type EXIT at the sqlcmd prompt.
-
Open a Command Prompt window, and type sqlcmd -SmyServer\instanceName. Replace myServer\instanceName with the name of the computer and the instance of [!INCLUDEssNoVersion] that you want to connect to.
-
Press ENTER.
The sqlcmd prompt (1>) indicates that you are connected to the specified instance of [!INCLUDEssNoVersion].
[!NOTE]
Entered [!INCLUDEtsql] statements are stored in a buffer. They are executed as a batch when the GO command is encountered.