SQL服务器查询分析器 [英] SQL server query analyzer

问题描述

什么是查询分析器？如何获取和使用它？

What is Query analyzer? How can I get and use this?

推荐答案

1) 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)

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

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

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

5) Debug stored procedures. (T-SQL Debugger)

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

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

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

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

10) 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.

谷歌是否已关闭？



在谷歌搜索。



查询分析器只不过是一个你可以运行的编辑器你的疑问。

Is google down?

Search it in google.

Query Analyzer is nothing but it is an editor where you can run your queries.

这篇关于SQL服务器查询分析器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！