Retrieving Data with Query Analyzer
The SQL Server Query Analyzer is your primary interface for executing T-SQL queries and stored procedures. You will be using this utility throughout the rest of your 21 days, and it's a good idea to get comfortable with several of the available options in this tool. For those of you who might have used previous versions of Microsoft SQL Server, it should be noted that for historical reasons, the Query Analyzer is named ISQLW.exe. This was the program name of the older version of the interactive SQL processor (see Figure 1.1). Although this older version was useful, the changes that have been made to the new Query Analyzer in SQL Server 2000 make it a much easier tool to use.
Figure 1.1. The old ISQL SQL processor. ...
Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
