Running Queries with 'sqlcmd' Tool in SQL Server

Q

How to run Queries with "sqlcmd" tool in SQL Server?

✍: FYIcenter.com

A

"sqlcmd" is a client tool that you can use to interact SQL server. You can follow the tutorial below to run queries on the local SQL Server 2005 Express.

1. Open a command window and enter the following command to start "sqlcmd" and run a simple query:

C:>"\Program Files\Microsoft SQL Server\90\Tools\binn\SQLCMD.EXE" 
   -S LOCALHOST\SQLEXPRESS
   
1> SELECT 'Welcome to FYIcenter.com SQL Server!';
2> GO
------------------------------------
Welcome to FYIcenter.com SQL Server!

(1 rows affected)

 

Downloading and Installing SQL Server 2005 Express Edition

⇒⇒SQL Server Database Tutorials

2016-12-04, 380👍, 0💬