RedGate SQL-Prompt is a slick add-in for SQL-Server Management Studio and Visual Studio. One feature is snippets which work the same way as Visual Studio code snippets e.g. type cw tab and get Console.WriteLine(""); while SQL-Prompt does SQL.

Any ways, the following link has additional snipplets that can be dropped into the snippet folder and be used immediately (SSMS is open).