Advertisement

Graphical and Command-Line Query Tools

Summary

This chapter drilled down on two tools for running T-SQL statements. Express SSMS is a rich graphical tool for running T-SQL statements. Express SSMS is especially designed for SQL Server Express, although you can use it to run T-SQL statements for other SQL Server 2005 editions and even other SQL Server versions, such as the MSDE version of SQL Server 2000. This chapter demonstrated many of the most important Express SSMS features, including how to
  • 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.

Keywords

Select Statement Server Instance Database Object Menu Item Query Statement 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Rick Dobson 2006

Personalised recommendations