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 Guide
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
Holiday Central
What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >
Family Tech Center
Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >
©2009 About.com, a part of The New York Times Company.
All rights reserved.