My 5 cents tip (you might know it already, but just in case)

[ivanrdgz]

I like to combine the SQL Prompt code snippets with the SQL Server Management Studio templates. I always liked the template (kind of the same idea of snippets) but SSMS lacks the ability of "calling" those templates right from your query window. I mean, you must go to the Template Collection, find the needed template and from there double click on it or drag and drop.

So, now what I do? I just create snippets using the template format. For example:

USE <Database, varchar,>
go

select * from <Table, varchar,>
go

Once I call it, I press CTRL+SHIFT+M and the template parameter window will show up allowing me to enter the defined paramaters of the current template.

Hope this will help someone

[aultmike]

Awesome tip!

[AndrewJacksonZA]

Thanks!!!