Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Yesterday @ 2:36 PM
Points: 33,052, Visits: 17,302
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:38 AM
Points: 2,109, Visits: 7,267
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


select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);


  • 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: Yesterday @ 2:36 PM
    Points: 33,052, Visits: 17,302
    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
    Posted Wednesday, October 21, 2015 2:13 AM
    SSC Veteran

    SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

    Group: General Forum Members
    Last Login: 2 days ago @ 7:05 AM
    Points: 217, Visits: 700
    We're probably going to be getting the Redgate tools fairly soon, so the developers will start using SQL Prompt. One of the things I need to do is set the code formatting standards for the department - has anyone got recommendations regarding casing, tabbing, etc.? If we're starting from scratch, I'd like to conform with generally accepted practice.

    Thanks.
    Post #1729580
    Posted Wednesday, October 21, 2015 8:24 AM


    SSC-Dedicated

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

    Group: Administrators
    Last Login: Yesterday @ 2:36 PM
    Points: 33,052, Visits: 17,302
    I don't think there are generally accepted standards. Some people like spaces, some tabs. Some use commas before, some at the end.

    Really, Prompt means you don't care. You set up Prompt as you want it, and then reformat code as you get it. What's the point of worrying about formatting if each person can change it with a couple keystrokes?







    Follow me on Twitter: @way0utwest

    Forum Etiquette: How to post data/code on a forum to get the best help
    Post #1729743
    Posted Wednesday, October 21, 2015 8:55 AM


    SSC Veteran

    SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

    Group: General Forum Members
    Last Login: 2 days ago @ 1:22 PM
    Points: 273, Visits: 1,505
    It would be nice if everyone could easily reformat to their liking. If that is not a possibility, maybe start with the ANSI standards or Microsoft's recommendations: Transact-SQL Syntax Conventions (Transact-SQL)

    Another suggestion is to lock down your server connnection settings, database settings, ANSI settings, and set coding standards such as no bracketed names allowed, two part object names that are schema scoped, etc. This will allow you to have readable code regardless of formatting. It also gives developers a stable, predictable environment in which to program.
    Post #1729755
    « Prev Topic | Next Topic »

    Add to briefcase

    Permissions Expand / Collapse