Microsoft SQL Server provides users with a variety of rich graphical user interfaces to retrieve and manipulate data and configure SQL Server databases. However, sometimes it’s just easier to work from the old-fashioned command line. Whether you’re looking for a quick-and-dirty way to execute a SQL query or wish to include SQL statements in a Windows script file, SQLCMD allows you to meet your goal.
This tutorial assumes that you already have Microsoft's AdventureWorks Sample Database installed.
SQLCMD Step-by-Step
By Mike Chapple, About.com
Prev
- Getting Familiar with SQLCMD
- Opening a Command Prompt
- Connecting to the Database
- Entering a Query
- Executing Your Query
- Exiting SQLCMD
Explore Databases
Must Reads
About.com Special Features
Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >
Easy ways to connect two computers for networking purposes. More >
©2009 About.com, a part of The New York Times Company.
All rights reserved.