O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using SSMS Snippets

A T-SQL code snippet is a new type of template that was added in SQL Server 2012. The templates are another great starting point when writing new T-SQL statements in the Database Engine Query Editor. They are tightly integrated into the query editor window and are supported by IntelliSense.

Snippets can be accessed in a number of different ways in SSMS. One easy way to access them is to right-click in a query editor window and choose Insert Snippet, which displays the snippet picker tooltip, as shown in Figure 4.29.

Image

FIGURE 4.29 Snippet picker tooltip.

When you select the desired snippet, the related T-SQL statements are added ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required