Using SQLCMD in sql server

Question

This might be a stupid question but I am learning about SQLCMD and the code for it. I don't really understand where to put the statement in.

This is what I am suppose to do. Use SQLCMD to output the results of the query SELECT COUNT(*) FROM Customers to the console window.

I have never done this before so I am thrown off a little. If someone would be able to help me understand it that would be great. I have done web searches and reviewed my book but it doesnt say where you will type the code into and I am working with SQL server 2008.

With the command prompt is that what you click start then accessories then to the command prompt and code it in there? — norris1023
– norris1023, Commented Nov 7, 2011 at 17:22

user596075 · Accepted Answer · 2011-11-07 16:56:26Z

3

I think the best way to show how it is used is with documentation. You can see the SQLCMD Reference here.

You use sqlcmd to execute Transact-SQL against an instance\database.

This is untested, but your example your desired command would be something like: sqlcmd -U <yourLogin> -Q "select count(*) from Customers" -S <yourMachineName>\<yourInstanceName>

After you hit "ENTER", you will be prompted for your password (this is provided you are using SQL Auth), and then upon authentication you will see the result of your query on the console window.

answered Nov 7, 2011 at 16:56

user596075

Sign up to request clarification or add additional context in comments.

Comments

zloctb · Accepted Answer · 2015-02-04 19:38:11Z

0

C:\Program Files\Microsoft SQL Server\110\Tools\Binn>sqlcmd -Q "use YourDB"
 C:\Program Files\Microsoft SQL Server\110\Tools\Binn>sqlcmd -Q "Select * From YourDB.dbo.param1"
id          num
----------- -----------
          3           1
          2           2
          3           3

answered Feb 4, 2015 at 19:38

zloctb

11.3k10 gold badges78 silver badges92 bronze badges

Collectives™ on Stack Overflow

Using SQLCMD in sql server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related