jump to navigation

Ctrl+Shift+M – SQL template October 28, 2009

Posted by msrviking in Tips & Tricks.

I was doing a regular reading through my favorite blogs and I learnt something new early in the morning. Here is what it is all about.

Being on development side of the applications I always recommend developers, leads and everyone who wants to write t-sql code to use standard templates. How could we achieve this quickly?

On opening your SSMS instead of a blank window, you could get your template by using Ctrl+Shift+M, and you could customize your template by replacing the content in the file or replacing the file itself but with same name in the following path

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql

The file you will want to edit to standardize the template will be Sqlfile.SQL.

I got this tip from my Buck Woody. Thanks Buck for sharing info on such small but important things.




No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: