You are here:Home » SQL Server General » Code Snippets in SQL Server Denali

Code Snippets in SQL Server Denali

SQL Server Denali introduced one more feature which can easily and reduces our t-SQL coding. This feature is "Code Snippets".

It allows to insert code template in the query editor. Here is some demonstration of this query editor new feature.



When you clink on Insert Snippets or Ctrl + K, Ctrl + X,



Let's double click on Index and an insert template of Create an Index.


Go ahead, click on Create a non clustered index will generate the index template as following,
CREATE UNIQUE NONCLUSTERED INDEX IX_TableName_Col1
    ON dbo.TableName
    (column_1)

I hope you liked this post. In the next post I will write how to create custom snippet.