[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 is a Senior SQL Server Architect, Author, a 9 Times Microsoft Data Platform MVP (2009-2018). He has over 20 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and {essentialDevTips.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). Moreover, Artemakis teaches on Udemy, you can check his courses here.
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