Click here to Skip to main content
14,241,004 members
   

Database

 
AnswerRe: I am not able to Generate Scripts for a larger table Pin
ZurdoDev4-Dec-18 2:24
professionalZurdoDev4-Dec-18 2:24 
QuestionHow do I remove the error message when I add file attachments database ? Pin
Member 245846729-Nov-18 21:17
memberMember 245846729-Nov-18 21:17 
AnswerRe: How do I remove the error message when I add file attachments database ? Pin
Richard MacCutchan29-Nov-18 22:56
protectorRichard MacCutchan29-Nov-18 22:56 
AnswerRe: How do I remove the error message when I add file attachments database ? Pin
ZurdoDev4-Dec-18 2:25
professionalZurdoDev4-Dec-18 2:25 
QuestionERD Help Pin
Prytol29-Nov-18 4:28
memberPrytol29-Nov-18 4:28 
SuggestionRe: ERD Help Pin
CHill6029-Nov-18 6:10
protectorCHill6029-Nov-18 6:10 
GeneralRe: ERD Help Pin
Prytol29-Nov-18 9:10
memberPrytol29-Nov-18 9:10 
AnswerRe: ERD Help Pin
Eddy Vluggen29-Nov-18 9:03
mveEddy Vluggen29-Nov-18 9:03 
If the primary key is always an autokey, we would not have to ask what identifies anything. We'd just have a hidden autonumber in every table, automatically.

Why can a vendor only have 1 "QtyArriving"?

This is why I like the database-normalization-steps; they provide you with an argumentation for every field and gives you the ammo to say "this is how it SHOULD be, and here is WHY".
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

QuestionWhat is the right database technology for this simple outlined BI tool use case? Pin
Member 1407009628-Nov-18 1:55
memberMember 1407009628-Nov-18 1:55 
AnswerRe: What is the right database technology for this simple outlined BI tool use case? Pin
Eddy Vluggen28-Nov-18 2:22
mveEddy Vluggen28-Nov-18 2:22 
GeneralRe: What is the right database technology for this simple outlined BI tool use case? Pin
Mycroft Holmes28-Nov-18 13:11
memberMycroft Holmes28-Nov-18 13:11 
GeneralRe: What is the right database technology for this simple outlined BI tool use case? Pin
Eddy Vluggen28-Nov-18 23:30
mveEddy Vluggen28-Nov-18 23:30 
AnswerRe: What is the right database technology for this simple outlined BI tool use case? Pin
Mycroft Holmes28-Nov-18 13:13
memberMycroft Holmes28-Nov-18 13:13 
QuestionSQL SERVER 2012 - pull data from only, if value date is available Pin
joflo26-Nov-18 23:30
memberjoflo26-Nov-18 23:30 
AnswerRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
Richard MacCutchan27-Nov-18 0:31
protectorRichard MacCutchan27-Nov-18 0:31 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
joflo27-Nov-18 0:48
memberjoflo27-Nov-18 0:48 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
Richard MacCutchan27-Nov-18 1:07
protectorRichard MacCutchan27-Nov-18 1:07 
AnswerRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
Richard Deeming27-Nov-18 1:21
mveRichard Deeming27-Nov-18 1:21 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
joflo27-Nov-18 1:48
memberjoflo27-Nov-18 1:48 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
Richard Deeming27-Nov-18 2:12
mveRichard Deeming27-Nov-18 2:12 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
joflo27-Nov-18 2:18
memberjoflo27-Nov-18 2:18 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
James Walsh Jr1-Jan-19 9:09
professionalJames Walsh Jr1-Jan-19 9:09 
QuestionOnly begin select if value is found in dataset sql Pin
Joanna Webster16-Nov-18 4:31
memberJoanna Webster16-Nov-18 4:31 
AnswerRe: Only begin select if value is found in dataset sql Pin
Richard MacCutchan16-Nov-18 22:10
protectorRichard MacCutchan16-Nov-18 22:10 
AnswerRe: Only begin select if value is found in dataset sql Pin
jschell21-Nov-18 7:43
memberjschell21-Nov-18 7:43 

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.