Click here to Skip to main content
13,148,427 members (67,016 online)
   

Database

 
GeneralRe: Subquery returns more than 1 row Pin
MaulikDusara26-Dec-12 18:45
memberMaulikDusara26-Dec-12 18:45 
GeneralRe: Subquery returns more than 1 row Pin
Eddy Vluggen27-Dec-12 4:24
memberEddy Vluggen27-Dec-12 4:24 
QuestionOn the Naming of Columns for Lookup tables. Pin
Brady Kelly17-Dec-12 22:44
memberBrady Kelly17-Dec-12 22:44 
AnswerRe: On the Naming of Columns for Lookup tables. Pin
Mycroft Holmes17-Dec-12 23:19
memberMycroft Holmes17-Dec-12 23:19 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly17-Dec-12 23:26
memberBrady Kelly17-Dec-12 23:26 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Mycroft Holmes18-Dec-12 1:11
memberMycroft Holmes18-Dec-12 1:11 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 1:15
memberBrady Kelly18-Dec-12 1:15 
AnswerRe: On the Naming of Columns for Lookup tables. Pin
PIEBALDconsult18-Dec-12 4:05
memberPIEBALDconsult18-Dec-12 4:05 
I mostly agree with Mycroft; the odds definitely favour what he recommends.

But as he and I seem to work on very different types of systems, I generally never display the column headings and in many cases ( Code , Meaning ) will suffice. Yet in many others a broader range of text values is required, so more descriptive names are suitable; one such I have here has ( ID , Tag , Description ) -- the Tag is used for a Dictionary and the Description is used in a ComboBox. There's another example here that pre-dates me wherein four different text values are required ( ID , Name , Description , LongName , ShortName ).

Oh, I just remembered another one that I created a week or two ago ( Code , Meaning , Description ) -- the Description is intended only as documentation for developers looking at the table; this table contains flags to be used in bitmaps.

What matters more is using names like "Name" and "Description" which are or may be reserved words -- you should probably avoid that, and by being in the habit of using more descriptive names you may never need to worry about that.

Consider each table on its own, don't try to enforce a single rule on all of them, but err on the side of caution. As I hope I showed here, habits are hard to break, so please try not to follow my path. Sigh | :sigh:

(Now I'm picturing Jacob Marley...)
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 4:12
memberBrady Kelly18-Dec-12 4:12 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
PIEBALDconsult18-Dec-12 4:46
memberPIEBALDconsult18-Dec-12 4:46 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 5:34
memberBrady Kelly18-Dec-12 5:34 
QuestionOn Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 3:02
memberBrady Kelly14-Dec-12 3:02 
JokeRe: On Strategies to Spell Check the Structure of a Database. Pin
Chris Meech14-Dec-12 4:31
memberChris Meech14-Dec-12 4:31 
AnswerRe: On Strategies to Spell Check the Structure of a Database. Pin
Simon_Whale14-Dec-12 4:52
memberSimon_Whale14-Dec-12 4:52 
AnswerRe: On Strategies to Spell Check the Structure of a Database. Pin
Mycroft Holmes14-Dec-12 13:12
memberMycroft Holmes14-Dec-12 13:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 16:36
memberBrady Kelly14-Dec-12 16:36 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Mycroft Holmes14-Dec-12 16:57
memberMycroft Holmes14-Dec-12 16:57 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 17:12
memberBrady Kelly14-Dec-12 17:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Mycroft Holmes14-Dec-12 21:13
memberMycroft Holmes14-Dec-12 21:13 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 21:25
memberBrady Kelly14-Dec-12 21:25 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
PIEBALDconsult15-Dec-12 8:49
memberPIEBALDconsult15-Dec-12 8:49 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly15-Dec-12 18:12
memberBrady Kelly15-Dec-12 18:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
PIEBALDconsult18-Dec-12 10:47
memberPIEBALDconsult18-Dec-12 10:47 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly18-Dec-12 11:01
memberBrady Kelly18-Dec-12 11:01 
Questionsending images from a SQL database to a user's email as attachment Pin
Member 946798213-Dec-12 2:16
memberMember 946798213-Dec-12 2:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy |
Web04 | 2.8.170924.2 | Last Updated 22 Sep 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid