Click here to Skip to main content
14,832,807 members
Home / Discussions / Database
   

Database

 
AnswerRe: Managing Database Changes Pin
David Mujica8-Nov-17 5:53
MemberDavid Mujica8-Nov-17 5:53 
AnswerRe: Managing Database Changes Pin
jschell8-Nov-17 7:33
Memberjschell8-Nov-17 7:33 
AnswerRe: Managing Database Changes Pin
Mycroft Holmes8-Nov-17 14:10
professionalMycroft Holmes8-Nov-17 14:10 
AnswerRe: Managing Database Changes Pin
kmoorevs11-Nov-17 9:58
Memberkmoorevs11-Nov-17 9:58 
GeneralRe: Managing Database Changes Pin
Richard Deeming13-Nov-17 1:49
mveRichard Deeming13-Nov-17 1:49 
GeneralRe: Managing Database Changes Pin
kmoorevs13-Nov-17 8:29
Memberkmoorevs13-Nov-17 8:29 
QuestionGet specific records from DB Pin
_Flaviu28-Oct-17 23:08
Member_Flaviu28-Oct-17 23:08 
AnswerRe: Get specific records from DB Pin
A_Griffin28-Oct-17 23:48
MemberA_Griffin28-Oct-17 23:48 
You need to select on the cars_features table more than once, so:
SELECT C.sName, C.sModel, C.sIdentifier 
FROM t_cars AS C INNER JOIN t_cars_feature AS CF1 ON CF1.nCars_ID = C.nCars_ID 
  INNER JOIN t_cars_feature AS CF2 ON CF2.nCars_ID = C.nCars_ID  
WHERE (CF1.nFeature_ID = 1 AND CF1.sValue = 1900) 
  AND (CF2.nFeature_ID = 3 AND CF2.sValue = 'Blue')

sName | sModel | sIdentifier
----------------------------
BMW | 3 series | D-78-JHG
AnswerRe: Get specific records from DB Pin
Mycroft Holmes28-Oct-17 23:54
professionalMycroft Holmes28-Oct-17 23:54 
QuestionA question about the behavior of Jet and Ace drivers Pin
indian14324-Oct-17 7:58
Memberindian14324-Oct-17 7:58 
GeneralRe: A question about the behavior of Jet and Ace drivers Pin
PIEBALDconsult24-Oct-17 8:32
professionalPIEBALDconsult24-Oct-17 8:32 
GeneralRe: A question about the behavior of Jet and Ace drivers Pin
indian14325-Oct-17 7:15
Memberindian14325-Oct-17 7:15 
GeneralRe: A question about the behavior of Jet and Ace drivers Pin
jschell27-Oct-17 7:43
Memberjschell27-Oct-17 7:43 
QuestionMath expression as Column value as string in the Dynamic Sql Pin
indian14319-Oct-17 7:19
Memberindian14319-Oct-17 7:19 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
Richard MacCutchan19-Oct-17 7:33
mveRichard MacCutchan19-Oct-17 7:33 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
indian14319-Oct-17 8:10
Memberindian14319-Oct-17 8:10 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
jschell20-Oct-17 9:27
Memberjschell20-Oct-17 9:27 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
Eddy Vluggen20-Oct-17 10:47
professionalEddy Vluggen20-Oct-17 10:47 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
indian14324-Oct-17 6:41
Memberindian14324-Oct-17 6:41 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
jschell25-Oct-17 9:19
Memberjschell25-Oct-17 9:19 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
indian14330-Oct-17 7:37
Memberindian14330-Oct-17 7:37 
QuestionGUID or long for MVC site Pin
#realJSOP17-Oct-17 6:37
mva#realJSOP17-Oct-17 6:37 
AnswerRe: GUID or long for MVC site Pin
Wendelius17-Oct-17 7:01
mveWendelius17-Oct-17 7:01 
AnswerRe: GUID or long for MVC site Pin
jschell17-Oct-17 7:43
Memberjschell17-Oct-17 7:43 
GeneralRe: GUID or long for MVC site Pin
k505418-Oct-17 5:30
mvek505418-Oct-17 5:30 

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.