November 1, 2010 at 7:32 am
Is it possible to get Microsoft SQL Server Management Studio to recognize abbreviations when typing code, e.g. when i type 'sf' and hit space I would like to get the following line written 'select top 10 *' and 'wh' should be 'where' and so on.. Does anyone know how to do this?
I have only seen this in SQuirreL and we are not allowed to use this tool on my work.
BR
Björn
November 1, 2010 at 7:37 am
Sql promt of red-gate has this feature.
Why are you not allowed 3rd party developpment tools at work??
November 1, 2010 at 7:49 am
rules and policies :unsure: !
November 1, 2010 at 7:49 am
I do not believe that you can do this with SSMS without a third party tool. you can use templates to keep snippets of commonly used code, which I've done for some complex joins.
November 1, 2010 at 9:30 am
If you can use freeware, http://www.ssmstoolspack.com has this feature.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
November 1, 2010 at 9:45 am
bjorng_83 (11/1/2010)
rules and policies :unsure: !
Rules or budget?
One way around this is to use a free tool or trial and PROVE increase productivity and code quality. Once that's done budgeting a few 100$ for a tool becomes a non-issue..
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy