home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 17,696 of 19,505   
   gargoyle60 to All   
   Column naming standard – general opinion   
   20 Nov 09 10:38:02   
   
   From: gargoyle60@example.invalid   
      
   Don't want to start a long-winded discussion, just seeking some   
   general views. . .   
      
   I was trained in SQL years ago and was encouraged to use lower-case   
   letters with words separated for emphasis using the underscore   
   character, for example:   
        customer_num, employee_id, invoice_line, transaction_code   
      
   I've stuck with this approach ever since, but now that I make use of   
   oo programming the general standard is to name oo instance variables   
   without underscores and capitalising all words except the first for   
   emphasis, such as:   
        customerNum, employeeId, invoiceLine, transactionCode   
      
   However, bridging the gap between relational databases and oo   
   programming means that when binding table column names to object   
   variable names, I really need to pick one or the other (you may   
   disagree but that's my aim).   
      
   So, when it comes to naming columns, what are most of you using?   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca