Graphical and Command-Line Query Tools
Connect to different SQL Server Express instances
Use three powerful designers for creating databases, tables, and views
Write, save, and reuse T-SQL code
Chapters 3 through Chapter 8 examine in-depth T-SQL coding techniques that you can use from within Express SSMS (or any other query tool).
The second tool covered in this chapter is the sqlcmd utility. This command-line application also runs T-SQL statements, but it offers no graphical user interface. The sqlcmd utility is especially designed for IT professionals and SQL Server power users. What the sqlcmd utility lacks in ease of use it compensates for by exposing an interface that makes it fast to invoke T-SQL statements without the overhead of a graphical user interface. In addition, the coverage of the sqlcmd utility included an example showing how to schedule the automatic running of sqlcmd tasks using the Windows Scheduled Tasks applet.
KeywordsSelect Statement Server Instance Database Object Menu Item Query Statement
Unable to display preview. Download preview PDF.