Collections:
Running Queries with 'sqlcmd' Tool in SQL Server
How to run Queries with "sqlcmd" tool in SQL Server?
✍: FYIcenter.com
"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)
2016-12-04, 1286👍, 0💬
Popular Posts:
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Count Duplicated Values in a Column in SQL Server? If you have a column with duplicated value...
What Is a Constant or Literal in SQL Server Transact-SQL? A constant, or data literal, is a symbolic...