Insert snippet - SQL Server 2012

The insert snippet let us create code easily.

To start the Insert Snippet, right click in the SQL Server Management Studio Script pane and select Insert Snippet.

You can easily generate code to create functions, indexes, logins, roles, schemas, stored procedures, synonyms, tables and triggers.

For stored procedure, it generates code for 3 scenarios:

• the basic procedure, 
• a procedure with cursors and 
• a procedure with output parameters