• Duncan Pryde (7/8/2010)


    It only "tabifies" groups of 4 spaces starting from the left, so if you have 5 spaces at the beginning of the line, you'll get a tab and a space after running this.

    I think it's the same in Visual Studio.

    Duncan

    Actually, it "tabifies" based upon the setting in Options|Text Editor|All Languages/Plain Text/Transact-SQL/XML|Tabs for the Tab Size setting.

    In my case, it's set to 2. Selecting tabify on your 5 spaces gives me 2 tabs and 1 space.

    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