Click here to Skip to main content
13,828,483 members
   

Database

 
QuestionGraph Database vs Dimensional Pin
DADom24-May-18 22:32
groupDADom24-May-18 22:32 
AnswerRe: Graph Database vs Dimensional Pin
Eddy Vluggen26-May-18 3:45
mveEddy Vluggen26-May-18 3:45 
GeneralRe: Graph Database vs Dimensional Pin
John 1356415428-Jun-18 10:07
memberJohn 1356415428-Jun-18 10:07 
GeneralRe: Graph Database vs Dimensional Pin
Eddy Vluggen28-Jun-18 10:19
mveEddy Vluggen28-Jun-18 10:19 
QuestionHow to create a insert trigger on just one table? Pin
Member23622-May-18 0:02
memberMember23622-May-18 0:02 
QuestionRe: How to create a insert trigger on just one table? Pin
CHill6022-May-18 2:34
protectorCHill6022-May-18 2:34 
AnswerRe: How to create a insert trigger on just one table? Pin
Richard Deeming22-May-18 3:30
mveRichard Deeming22-May-18 3:30 
AnswerRe: How to create a insert trigger on just one table? Pin
Mycroft Holmes22-May-18 15:09
memberMycroft Holmes22-May-18 15:09 
This is a REALLY BAD design, instead of having a separate table for productname create a view

create view vwProductName
as
select distinct product as productname from product

Never underestimate the power of human stupidity
RAH

GeneralRe: How to create a insert trigger on just one table? Pin
CHill6022-May-18 23:56
protectorCHill6022-May-18 23:56 
GeneralRe: How to create a insert trigger on just one table? Pin
Mycroft Holmes23-May-18 14:20
memberMycroft Holmes23-May-18 14:20 
GeneralRe: How to create a insert trigger on just one table? Pin
Member23623-May-18 0:04
memberMember23623-May-18 0:04 
GeneralRe: How to create a insert trigger on just one table? Pin
Mycroft Holmes23-May-18 14:23
memberMycroft Holmes23-May-18 14:23 
QuestionFOR XML PATH is not creating Child elements if they are coming with null values Pin
indian14316-May-18 13:39
memberindian14316-May-18 13:39 
AnswerRe: FOR XML PATH is not creating Child elements if they are coming with null values Pin
CHill6022-May-18 2:32
protectorCHill6022-May-18 2:32 
QuestionEquivalent of the following query without FOR XML PATH Pin
indian14314-May-18 13:03
memberindian14314-May-18 13:03 
SuggestionRe: Equivalent of the following query without FOR XML PATH Pin
CHill6015-May-18 1:11
protectorCHill6015-May-18 1:11 
GeneralRe: Equivalent of the following query without FOR XML PATH Pin
indian14315-May-18 7:39
memberindian14315-May-18 7:39 
GeneralRe: Equivalent of the following query without FOR XML PATH Pin
CHill6015-May-18 23:11
protectorCHill6015-May-18 23:11 
GeneralRe: Equivalent of the following query without FOR XML PATH Pin
indian14317-May-18 15:56
memberindian14317-May-18 15:56 
RantLatest Oracle Connection method Pin
Mycroft Holmes6-May-18 15:56
memberMycroft Holmes6-May-18 15:56 
GeneralRe: Latest Oracle Connection method Pin
Jörgen Andersson16-May-18 1:20
protectorJörgen Andersson16-May-18 1:20 
GeneralRe: Latest Oracle Connection method Pin
Mycroft Holmes16-May-18 1:27
memberMycroft Holmes16-May-18 1:27 
GeneralRe: Latest Oracle Connection method Pin
Jörgen Andersson16-May-18 1:37
protectorJörgen Andersson16-May-18 1:37 
QuestionSQL 2016 Optimization ... Pin
Member 138060854-May-18 2:10
memberMember 138060854-May-18 2:10 
RantRe: SQL 2016 Optimization ... Pin
CHill604-May-18 2:13
protectorCHill604-May-18 2:13 

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 | Cookies | Terms of Service
Web06 | 2.8.190114.1 | Last Updated 10 Jan 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid