SQL Query Analyzer is a tool that allows graphic creation of queries and SQL scripts. It makes use of templates

Template (programming)

Templates are a feature of the C++ programming language that allow functions and classes to operate with generic types. This allows a function or class to work on many different data types without being rewritten for each one....

.

Microsoft SQL Server 2000 SQL Query Analyzer is a graphical tool that allows you to:

• Create queries and other SQL scripts and execute them against SQL Server databases. (Query window)

• Quickly create commonly used database objects from predefined scripts. (Templates)

• Quickly copy existing database objects. (Object Browser scripting feature)

• Execute stored procedures without knowing the parameters. (Object Browser procedure execution feature)

• Debug stored procedures. (T-SQL Debugger)

• Debug query performance problems. (Show Execution Plan, Show Server Trace, Show Client Statistics, Index Tuning Wizard)

• Locate objects within databases (object search feature), or view and work with objects. (Object Browser)

• Quickly insert, update, or delete rows in a table. (Open Table window)

• Create keyboard shortcuts for frequently used queries. (custom query shortcuts feature)

• Add frequently used commands to the Tools menu. (customized Tools menu feature)

You can run SQL Query Analyzer directly from the Start menu, or you run it from inside SQL Server Enterprise Manager. You can also run SQL Query Analyzer from the command prompt by executing the isqlw utility.

The source of this article is wikipedia, the free encyclopedia.  The text of this article is licensed under the GFDL.