Click here to Skip to main content
14,448,968 members
   

Database

 
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
mveCHill6022-May-18 2:34 
AnswerRe: How to create a insert trigger on just one table? Pin
Richard Deeming22-May-18 3:30
communityengineerRichard 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 
GeneralRe: How to create a insert trigger on just one table? Pin
CHill6022-May-18 23:56
mveCHill6022-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 
The comments still stand - there should be no reason to store the productname in a different table especially as it is user input and free form.
Never underestimate the power of human stupidity
RAH

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
mveCHill6022-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
mveCHill6015-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
mveCHill6015-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
communityengineerJö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
communityengineerJö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
mveCHill604-May-18 2:13 
AnswerRe: SQL 2016 Optimization ... Pin
Eddy Vluggen5-May-18 2:14
professionalEddy Vluggen5-May-18 2:14 
QuestionSQL 2016 Optimization ... Pin
Member 138060854-May-18 2:10
MemberMember 138060854-May-18 2:10 
QuestionHow to stop execution of other tasks in SSIS if a script task gets Dts.TaskResult = (int)ScriptResults.Failure; Pin
indian1432-May-18 15:12
Memberindian1432-May-18 15:12 
AnswerSelf answered just if somebody has similar problem it would be helpful. How to stop execution of other tasks in SSIS if a script task gets Dts.TaskResult = (int)ScriptResults.Failure; Pin
indian1433-May-18 9:41
Memberindian1433-May-18 9:41 

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.