推薦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.