Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / All-Topics

Tip 3: Exciting SSMS Features Derived from Visual Studio

5.00/5 (1 vote)
14 Feb 2015CPOL1 min read 5.4K  
Tip 3: Exciting SSMS Features Derived from Visual Studio

In this series of posts, we’ll see a few great yet less known and under utilized tips/features that are there since earlier versions of Visual Studio and later made their way to SSMS (SQL Server Management Studio). I am sure, you’ll love these tips.

Have you used code snippet feature in Visual Studio? Aren’t they very useful?

What are code snippets?
Code Snippets are reusable code templates that help to write code faster.

What are Transact SQL code snippets?
“A Transact-SQL code snippet is a template containing the basic structure of a Transact-SQL statement or block. You can use snippets as a starting point when adding statements in the Database Engine Query Editor. You can insert the pre-defined snippets supplied with SQL Server, or create your own.”MSDN

We’ll discuss about how we can create a Transact SQL code snippet of our own on a later blog post. For now, we’ll see how we can use them.

You can do it either way:

801800

  • Right click on the query window and click Insert Snippet…
  • Using keyboard shortcuts CTRL+K, CTRL+X

    802

Then, choose the appropriate category and then the appropriate template to insert it into your query window.

Hopefully you liked this tip. Please stay tuned to learn few more exciting tips in this series. I will love to hear from you. Thanks for reading.

Image 4 Image 5

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)