• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 23. Administering Databases with... > Working with SQL Query Analyzer

Working with SQL Query Analyzer

SQL Query Analyzer is an ad hoc T-SQL query tool that offers a graphical representation of SQL Server query plans. Unlike ADP, which require you to save queries as views, functions, or stored procedures before execution, Query Analyzer lets you type and execute T-SQL statements without creating a persistent query object. This feature makes Query Analyzer a very useful tool when you're learning T-SQL.

Executing SELECT Queries, Functions, and Stored Procedures

To give Query Analyzer a test drive with the three types of SQL Server queries, do the following:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint