[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 14-day trial of Snippets Generator here.
Prerequisites:
-
- .NET Framework 3.5 SP1
- SQL Server 2012 (for importing the generated snippets(s))
Drop us a line if you like the tool! Your valuable feedback is always welcome and much appreciated!
Learn essential SQL Server development tips! Enroll to our Online Course!
Check our online course titled “Essential SQL Server Development Tips for SQL Developers”
(special limited-time discount included in link).
Sharpen your SQL Server database programming skills via a large set of tips on T-SQL and database development techniques. The course, among other, features over than 30 live demonstrations!
Reference: SQLNetHub (https://www.sqlnethub.com)
© SQLNetHub
Artemakis Artemiou, a distinguished Senior Database and Software Architect, brings over 20 years of expertise to the IT industry. A Certified Database, Cloud, and AI professional, he earned the Microsoft Data Platform MVP title for nine consecutive years (2009-2018). As the founder of SQLNetHub and GnoelixiAI Hub, Artemakis is dedicated to sharing his knowledge and democratizing education on various fields such as: Databases, Cloud, AI, and Software Development. His commitment to simplicity and knowledge sharing defines his impactful presence in the tech community.
Artemis,
Excellent!
Many thanks for sharing!!!
Demetris.
Thank you very much Demetris!
I am glad you found the tool useful!
It's a pleasure sharing technical knowledge with the community!
Cheers,
Artemis