Using Microsoft SQL Server 7
Microsoft SQL Server 7 features a Windows-based query analysis tool called Query Analyzer. Although this tool is primarily designed to analyze SQL statement execution and optimization, it does present an ideal environment for testing and experimenting with SQL statements. Here's how to use the Query Analyzer:
1. | Launch the Query Analyzer application (from the Microsoft SQL Server 7 program group). |
2. | You'll be prompted for server and login information. Log in to your SQL Server (starting the server if appropriate). |
3. | When the query screen is displayed, select the database from the drop-down DB list box. |
4. | Type your SQL in the large text window, and then click the Execute Query button (the one with the green arrow) ... |
Get Sams Teach Yourself SQL in 10 Minutes, 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.
