It took me a small amount of Googling with Bing to find this post on Stack Overflow.
But it works for SQL 2008 r2 - apart from changing the paths slightly.
%Install Dir%:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql\SQLFile.sql
I cant work out why is there nothing on MSDN about this cool feature?
Or why is not part of the SQL templates.
References:
http://sqlsoundings.blogspot.com/2010/03/using-ssms-templates-for-fun-and-profit.html
http://msdn.microsoft.com/en-us/library/ms174169.aspx
http://stackoverflow.com/questions/593047/mssql-server-management-studio-ssms-2005-new-query-template
No comments:
Post a Comment