彩票走势图

推荐SQL Search的原因

• 影响分析

您是否有碰到过这种情况：想重命名某个表列，却无法确定是否有预存程序与之有涉及。现在用户可以使用SQL Search，搜索该列名，查找到在哪些预存流程中有使用到它。

• 运行速度更快

以往在SSMS对象树中查找任何事情都需要进行大量的鼠标点击操作。有了SQL Search，用户只需点击快捷复组合框，开始输入名称，即可迅速跳至那里。

• 使开发过程更简单

以前，开发者们需要进行查找以确定那些尚未完成编码的预存程序。而现在，他们使用SQL Search，只需查找到那些包含“TODO”的预存程序即可。

• 提高开发效率，减少错误

如果您是一名DBA，却发现开发者们在他们的视图里和预存程序中经常使用“SELECT *”，您尝试找到所有使用了该语句的地方，并用列列表取代它以提高程序的效率和阻止将来可能发生的故障。有了SQL Search，用户可以在预存程序和视图文本中迅速查找发现“SELECT *”

Why use SQL Search?

• 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.