推薦SQL Search的原因

• 影響分析

您是否有碰到過這種情況：想重命名某個(gè)表列，卻無法確定是否有預(yù)存程序與之有涉及?，F(xiàn)在用戶可以使用SQL Search，搜索該列名，查找到在哪些預(yù)存流程中有使用到它。

• 運(yùn)行速度更快

以往在SSMS對(duì)象樹中查找任何事情都需要進(jìn)行大量的鼠標(biāo)點(diǎn)擊操作。有了SQL Search，用戶只需點(diǎn)擊快捷復(fù)組合框，開始輸入名稱，即可迅速跳至那里。

• 使開發(fā)過程更簡(jiǎn)單

以前，開發(fā)者們需要進(jìn)行查找以確定那些尚未完成編碼的預(yù)存程序。而現(xiàn)在，他們使用SQL Search，只需查找到那些包含“TODO”的預(yù)存程序即可。

• 提高開發(fā)效率，減少錯(cuò)誤

如果您是一名DBA，卻發(fā)現(xiàn)開發(fā)者們?cè)谒麄兊囊晥D里和預(yù)存程序中經(jīng)常使用“SELECT *”，您嘗試找到所有使用了該語句的地方，并用列列表取代它以提高程序的效率和阻止將來可能發(fā)生的故障。有了SQL Search，用戶可以在預(yù)存程序和視圖文本中迅速查找發(fā)現(xiàn)“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.