[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)
Artemakis Artemiou is a Senior SQL Server Architect, Author, and a 9 Times Microsoft Data Platform MVP (2009-2018). He has over 15 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and TechHowTos.com. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA).