Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Prompt Tips #2 - Casing Options Expand / Collapse
Author
Message
Posted Wednesday, May 7, 2014 1:28 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:34 PM
Points: 31,181, Visits: 15,626
Comments posted to this topic are about the item SQL Prompt Tips #2 - Casing Options






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1568669
Posted Wednesday, May 7, 2014 5:56 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:19 PM
Points: 1,796, Visits: 5,799
Nice tips, but be careful with statements like this:

The case doesn't change the logic


In a case sensitive installation/database, it most certainly can change the logic as you must be consistent not only with the casing of object names, but also variable names inside a batch.

I don't use SQL Prompt myself, but I hope it recognises when a database has CS collation and does not refactor object names (for case preferences) or variable names in these situations?


MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1568736
    Posted Thursday, May 8, 2014 9:18 AM


    SSC-Dedicated

    SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

    Group: Administrators
    Last Login: Today @ 12:34 PM
    Points: 31,181, Visits: 15,626
    The case doesn't change the logic for keywords or functions, or data types. Those are what is reformatted. Prompt doesn't reformat the object names as far as case goes.






    Follow me on Twitter: @way0utwest

    Forum Etiquette: How to post data/code on a forum to get the best help
    Post #1568972
    « Prev Topic | Next Topic »

    Add to briefcase

    Permissions Expand / Collapse