[Update 2018] Please visit Snippet’s Generator page for the latest release of the tool and much more.
T-SQL code snippets is a very handy new feature originally shipped in SQL Server 2012.
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!
Since SQL Server and SSMS 2012 you can import your own 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.
We have built a tool to help you with creating T-SQL code snippets for SSMS and SQL Server 2012 and later. This tool is “Snippets Generator”
Using this tool you can generate T-SQL code snippets for SQL Server 2012 and later, save it into a directory and then add the directory, and consequently your custom snippets, into SQL Server 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 download the free 30-day trial of Snippets Generator here.
- .NET Framework 3.5 SP1
- SQL Server 2012 CTP1 (for importing the generated snippets(s) 🙂
Drop us a line if you like the tool! Your valuable feedback is always welcome and much appreciated!
Reference: SQLNetHub (https://www.sqlnethub.com)