Well maybe it's not fun, fun. Not robots or bleeding edge coolness, but I'll tell you what isn't fun, it's writing the same code over and over. For loops, property setters, custom code snips, common T-SQL patterns, etc. You know what I mean, that same little block of code that you might copy-n-paste-n-tweak all the time? Or that statement group you type so often you don't even have to think about it, the muscle memory is so ingrain that you can do it with your eyes close?

"Greg, give us a break, we all know about code snippets! Visual Studio has a bunch..."

You're right, it does. But everyone also knows that the ones in the box are the starting point, not the end point. The real fun starts when you start creating your own...

Using code snippets you can save time when you write code and you just need to enter code that does common tasks. Code reuse has always been useful and it really increases productivity!

In SQL Server 2012 you can import your own custom-made snippets. However, prior to that, you need to create a snippet.

Each snippet is an XML file that specifies some header information regarding the snippet and then it includes the T-SQL code.

A sample T-SQL code snippet for SQL Server 2012 is illustrated in the following image:

Using Snippets Generator, you can generate T-SQL code snippets, save it into a directory and then add the directory, and consequently your custom snippets, into SQL Server 2012 Management Studio (SSMS) via the Code Snippets Manager! The directory's name will be the snippet category name in Code Snippet Manager and its contents will be the snippets!

You can either create a snippet from scratch or just make use of one of the snippet templates shipped with the tool in order to assist you with the design of your custom snippet.

Additionally, you can open an existing snippet generate a new one based on the original.

Oh yeah, the source for this project is available to. It's not as complex with the first, but sometimes simpler is better...