using abbreviations when writing sql

  • 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

  • Sql promt of red-gate has this feature.

    Why are you not allowed 3rd party developpment tools at work??

  • rules and policies :unsure: !

  • 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.

  • 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


    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • 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