Training
Learning path
Get Started Querying with Transact-SQL - Training
Get Started Querying with Transact-SQL
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL database in Microsoft Fabric
The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files at the command prompt, in Edit SQLCMD Scripts with Query Editor in About SQL Server Management Studio, and in a Windows script file or in an operating system (Cmd.exe) job step of a SQL Server Agent job.
Note
Windows Authentication is the default authentication mode for sqlcmd. To use SQL Server Authentication, you must specify a user name and password by using the -U
and -P
options.
By default, SQL Server Express installs as the named instance sqlexpress
.
On the Start menu, select Run. In the Open box type cmd, and then select OK to open a Command Prompt window. (If you haven't connected to this instance of the SQL Server Database Engine before, you might have to configure SQL Server to accept connections.)
At the command prompt, type sqlcmd
.
Press ENTER
.
You now have a trusted connection to the default instance of SQL Server 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 -S<myServer\instanceName>
. Replace <myServer\instanceName>
with the name of the computer and the instance of the SQL Server Database Engine that you want to connect to.
Press ENTER
.
The sqlcmd prompt (1>
) indicates that you're connected to the specified instance of SQL Server.
The Transact-SQL statements you enter are stored in a buffer. They're executed as a batch when the GO
command is encountered.
Training
Learning path
Get Started Querying with Transact-SQL - Training
Get Started Querying with Transact-SQL