Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Prompt Tips #2 - Casing Options


SQL Prompt Tips #2 - Casing Options

Author
Message
Steve Jones
Steve Jones
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: Administrators
Points: 40571 Visits: 18848
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
My Blog: www.voiceofthedba.com
mister.magoo
mister.magoo
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2605 Visits: 7851
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

  • Steve Jones
    Steve Jones
    SSC-Forever
    SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

    Group: Administrators
    Points: 40571 Visits: 18848
    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
    My Blog: www.voiceofthedba.com
    Chris Wooding
    Chris Wooding
    Old Hand
    Old Hand (369 reputation)Old Hand (369 reputation)Old Hand (369 reputation)Old Hand (369 reputation)Old Hand (369 reputation)Old Hand (369 reputation)Old Hand (369 reputation)Old Hand (369 reputation)

    Group: General Forum Members
    Points: 369 Visits: 948
    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.
    Steve Jones
    Steve Jones
    SSC-Forever
    SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

    Group: Administrators
    Points: 40571 Visits: 18848
    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
    My Blog: www.voiceofthedba.com
    Bill Talada
    Bill Talada
    Mr or Mrs. 500
    Mr or Mrs. 500 (525 reputation)Mr or Mrs. 500 (525 reputation)Mr or Mrs. 500 (525 reputation)Mr or Mrs. 500 (525 reputation)Mr or Mrs. 500 (525 reputation)Mr or Mrs. 500 (525 reputation)Mr or Mrs. 500 (525 reputation)Mr or Mrs. 500 (525 reputation)

    Group: General Forum Members
    Points: 525 Visits: 1861
    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.
    Go


    Permissions

    You can't post new topics.
    You can't post topic replies.
    You can't post new polls.
    You can't post replies to polls.
    You can't edit your own topics.
    You can't delete your own topics.
    You can't edit other topics.
    You can't delete other topics.
    You can't edit your own posts.
    You can't edit other posts.
    You can't delete your own posts.
    You can't delete other posts.
    You can't post events.
    You can't edit your own events.
    You can't edit other events.
    You can't delete your own events.
    You can't delete other events.
    You can't send private messages.
    You can't send emails.
    You can read topics.
    You can't vote in polls.
    You can't upload attachments.
    You can download attachments.
    You can't post HTML code.
    You can't edit HTML code.
    You can't post IFCode.
    You can't post JavaScript.
    You can post emoticons.
    You can't post or upload images.

    Select a forum

































































































































































    SQLServerCentral


    Search