Click here to Skip to main content
12,628,919 members (33,558 online)
   

Database

 
QuestionSubquery returns more than 1 row Pin
Jassim Rahma24-Dec-12 2:02
memberJassim Rahma24-Dec-12 2:02 
AnswerRe: Subquery returns more than 1 row Pin
Eddy Vluggen24-Dec-12 2:29
memberEddy Vluggen24-Dec-12 2:29 
AnswerRe: Subquery returns more than 1 row Pin
MaulikDusara24-Dec-12 22:44
memberMaulikDusara24-Dec-12 22:44 
GeneralRe: Subquery returns more than 1 row Pin
Eddy Vluggen25-Dec-12 3:41
memberEddy Vluggen25-Dec-12 3:41 
GeneralRe: Subquery returns more than 1 row Pin
Mycroft Holmes26-Dec-12 12:17
memberMycroft Holmes26-Dec-12 12:17 
GeneralRe: Subquery returns more than 1 row Pin
MaulikDusara26-Dec-12 19:45
memberMaulikDusara26-Dec-12 19:45 
GeneralRe: Subquery returns more than 1 row Pin
Eddy Vluggen27-Dec-12 5:24
memberEddy Vluggen27-Dec-12 5:24 
QuestionOn the Naming of Columns for Lookup tables. Pin
Brady Kelly17-Dec-12 23:44
memberBrady Kelly17-Dec-12 23:44 
AnswerRe: On the Naming of Columns for Lookup tables. Pin
Mycroft Holmes18-Dec-12 0:19
memberMycroft Holmes18-Dec-12 0:19 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 0:26
memberBrady Kelly18-Dec-12 0:26 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Mycroft Holmes18-Dec-12 2:11
memberMycroft Holmes18-Dec-12 2:11 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 2:15
memberBrady Kelly18-Dec-12 2:15 
AnswerRe: On the Naming of Columns for Lookup tables. Pin
PIEBALDconsult18-Dec-12 5:05
memberPIEBALDconsult18-Dec-12 5:05 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 5:12
memberBrady Kelly18-Dec-12 5:12 
PIEBALDconsult wrote:
Description is intended only as documentation for developers looking at the table
That kind of info I am storing in a separate data dictionary, which has not yet moved beyond an Excel doc, but I am seriously considering writing something to use SQL Server's Extended Properties for data dictionary data.
PIEBALDconsult wrote:
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.
Yes, and even names that aren't reserved but are prickly, like having a table called ReferenceType with Id and Type columns. I have avoided all of those things.
GeneralRe: On the Naming of Columns for Lookup tables. Pin
PIEBALDconsult18-Dec-12 5:46
memberPIEBALDconsult18-Dec-12 5:46 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 6:34
memberBrady Kelly18-Dec-12 6:34 
QuestionOn Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 4:02
memberBrady Kelly14-Dec-12 4:02 
JokeRe: On Strategies to Spell Check the Structure of a Database. Pin
Chris Meech14-Dec-12 5:31
memberChris Meech14-Dec-12 5:31 
AnswerRe: On Strategies to Spell Check the Structure of a Database. Pin
Simon_Whale14-Dec-12 5:52
memberSimon_Whale14-Dec-12 5:52 
AnswerRe: On Strategies to Spell Check the Structure of a Database. Pin
Mycroft Holmes14-Dec-12 14:12
memberMycroft Holmes14-Dec-12 14:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 17:36
memberBrady Kelly14-Dec-12 17:36 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Mycroft Holmes14-Dec-12 17:57
memberMycroft Holmes14-Dec-12 17:57 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 18:12
memberBrady Kelly14-Dec-12 18:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Mycroft Holmes14-Dec-12 22:13
memberMycroft Holmes14-Dec-12 22:13 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 22:25
memberBrady Kelly14-Dec-12 22:25 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
PIEBALDconsult15-Dec-12 9:49
memberPIEBALDconsult15-Dec-12 9:49 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly15-Dec-12 19:12
memberBrady Kelly15-Dec-12 19:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
PIEBALDconsult18-Dec-12 11:47
memberPIEBALDconsult18-Dec-12 11:47 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly18-Dec-12 12:01
memberBrady Kelly18-Dec-12 12:01 
Questionsending images from a SQL database to a user's email as attachment Pin
Member 946798213-Dec-12 3:16
memberMember 946798213-Dec-12 3:16 
QuestionRe: sending images from a SQL database to a user's email as attachment Pin
Eddy Vluggen13-Dec-12 3:29
memberEddy Vluggen13-Dec-12 3:29 
QuestionODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 6:23
memberGenJerDan12-Dec-12 6:23 
AnswerRe: ODBC Returns Wrong Data Pin
Chris Meech12-Dec-12 6:50
memberChris Meech12-Dec-12 6:50 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 7:20
memberGenJerDan12-Dec-12 7:20 
GeneralRe: ODBC Returns Wrong Data Pin
Chris Meech12-Dec-12 7:28
memberChris Meech12-Dec-12 7:28 
AnswerRe: ODBC Returns Wrong Data Pin
PIEBALDconsult12-Dec-12 7:28
memberPIEBALDconsult12-Dec-12 7:28 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 8:18
memberGenJerDan12-Dec-12 8:18 
GeneralRe: ODBC Returns Wrong Data Pin
PIEBALDconsult12-Dec-12 9:51
memberPIEBALDconsult12-Dec-12 9:51 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 9:54
memberGenJerDan12-Dec-12 9:54 
AnswerRe: ODBC Returns Wrong Data Pin
jschell12-Dec-12 10:05
memberjschell12-Dec-12 10:05 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 10:14
memberGenJerDan12-Dec-12 10:14 
GeneralRe: ODBC Returns Wrong Data Pin
jschell14-Dec-12 13:38
memberjschell14-Dec-12 13:38 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan14-Dec-12 14:24
memberGenJerDan14-Dec-12 14:24 
AnswerRe: ODBC Returns Wrong Data Pin
Mycroft Holmes12-Dec-12 13:01
memberMycroft Holmes12-Dec-12 13:01 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan13-Dec-12 4:05
memberGenJerDan13-Dec-12 4:05 
QuestionRe: ODBC Returns Wrong Data Pin
Eddy Vluggen13-Dec-12 5:24
memberEddy Vluggen13-Dec-12 5:24 
QuestionUsing .Net and SMO on multiple SQL versions Pin
EricCiz12-Dec-12 0:45
memberEricCiz12-Dec-12 0:45 
AnswerRe: Using .Net and SMO on multiple SQL versions Pin
Eddy Vluggen12-Dec-12 4:10
memberEddy Vluggen12-Dec-12 4:10 
QuestionSelecting issue in SQl Server Pin
rakeshs31212-Dec-12 0:06
memberrakeshs31212-Dec-12 0:06 
AnswerRe: Selecting issue in SQl Server Pin
Eddy Vluggen12-Dec-12 4:07
memberEddy Vluggen12-Dec-12 4:07 

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 | Mobile
Web01 | 2.8.161205.3 | Last Updated 6 Dec 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid