Tutorial on using the SQL search edition SQL query and analysis tool in red gate Series

Source: Internet
Author: User
Tags management studio sql server management sql server management studio
Tutorial on using the SQL search edition SQL query and analysis tool in red gate Series

Red Gate SeriesArticle: 

SQL compare edition, one of the red gate series, database comparison tool, complete cracking + tutorial


Red Gate Series ii SQL source control edition database version controller full cracking + tutorial


Red Gate Series iii SQL Server development tool SQL prompt edition T-SQL smart sensing analyzer complete cracking + use tutorial


Red Gate Series 4 SQL data compare edition data comparison and synchronization Tool complete cracking + tutorial


Red Gate Series 5. Net reflector edition. Net Program decompilation artifact (with plug-in installation tutorial) Complete cracking + use tutorial


Red Gate Series 6 SQL test edition SQL test tool full cracking + tutorial


Tutorial on using the SQL search edition SQL query and analysis tool in red gate Series


8. Red Gate series SQL connect edition database connection and operation tool cracking + usage tutorial


SQL search-quickly find SQL in SSMs
    • Find fragments of SQL text within stored procedures, functions, views and more
    • Quickly navigate to objects wherever they happen to be on a server
    • Find all references to an object

Click the video to view

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 audit SS 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.

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.

SQL search is a free SQL query tool developed by red-gate. It can search all SQL statements in SSMs, including stored procedures, functions, views, triggers, the referenced object and more.

The red gate series are not complete and will be resumed.

Do not delete the following lines. Thank you !!!

Source from vallen cnblogs link: http://www.cnblogs.com/VAllen/archive/2012/10/01/SQLSearch.html

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.