This snippet creates a blank safe transaction in which to perform database CRUD operations.
SQL 2012 Managment Studio only :(
I frequently find myself needing to update database table values in databases which shouldn't really be manipulated manually, but sometimes need to be.
Using the code
Save this code in a file called "SafeSQLSnippet.snippet" (or whatever you want)
in C:\Users\USERNAME\Documents\SQL Server Management Studio\Code Snippets\SQL\My Code Snippets.
<Description>Inserts a TRAN-TRY-CATCH.</Description>
Points of Interest
Should serve as a sort-of tutorial for creating other snippets.
Got tired of writing this code over and over, or remembering were to copy/paste it from.