Red Gate系列之七 SQL Search 1.1.6.1 Edition SQL查询分析工具使用教程

浏览数：35 / 时间：2015年06月12日

Red Gate系列文章：

SQL Search - quickly find SQL in SSMS

请单击视频查看

SQL Search integrates into Management Studio

Scope the extent of your search

Results are returned as you type

Quickly jump to the found objects

SQL Search is an add-in for SQL Server Management Studio that lets you quickly search for SQL across your databases.

SQL Search will eventually become part of SQL Prompt. When this happens, the free version of SQL Search will continue to work without issue.

Until then, we‘re making it available as a free standalone tool.

Impact Analysis
You want to rename one of your table columns but aren‘t sure what stored procedures reference it. Using SQL Search, you can search for the column name and find all the stored procedures where it is used.
Work faster
Finding anything in the SSMS object tree requires a lot of clicking. Using SQL Search, you can press the shortcut combo, start typing the name, and jump right there.
Make your life easier
You need to find stored procedures you‘ve not yet finished writing. Using SQL Search, you can search for stored procedures containing the text ‘TODO‘.
Increase efficiency, reduce errors
You are a DBA, and developers keep using ‘SELECT *‘ in their views and stored procedures. You want to find all these and replace them with a correct list of columns to improve performance and prevent future bugs. Using SQL Search, you can look for ‘SELECT *‘ in the text of stored procedures and views.

SQL Search是Red-Gate开发的一个免费SQL查询工具，它可以搜索SSMS中的所有SQL，其中包括：存储过程，函数，视图，触发器，被引用的对象以及更多。

Red Gate系列未完，待续。

转载的朋友,请不要删除以下行,对此,表示感谢!!!

郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。