Click here to Skip to main content
12,070,351 members (51,293 online)
   

Database

 
AnswerRe: check before insert Pin
Eddy Vluggen31-Jan-13 6:00
mvpEddy Vluggen31-Jan-13 6:00 
GeneralRe: check before insert Pin
Eddy Vluggen31-Jan-13 11:35
mvpEddy Vluggen31-Jan-13 11:35 
AnswerRe: check before insert Pin
mark merrens31-Jan-13 9:10
membermark merrens31-Jan-13 9:10 
GeneralRe: check before insert Pin
vanikanc31-Jan-13 9:21
membervanikanc31-Jan-13 9:21 
GeneralRe: check before insert Pin
mark merrens31-Jan-13 11:09
membermark merrens31-Jan-13 11:09 
GeneralRe: check before insert Pin
Chris Meech31-Jan-13 11:24
memberChris Meech31-Jan-13 11:24 
GeneralRe: check before insert Pin
mark merrens31-Jan-13 11:25
membermark merrens31-Jan-13 11:25 
AnswerRe: check before insert Pin
djj551-Feb-13 8:50
memberdjj551-Feb-13 8:50 
If you are using SQL server 2008 look at the MERGE command. It will Update or Insert.

As to the failure, as stated look at transactions or possibly Try Catch.
GeneralRe: check before insert Pin
vanikanc1-Feb-13 8:55
membervanikanc1-Feb-13 8:55 
GeneralRe: check before insert Pin
djj551-Feb-13 9:25
memberdjj551-Feb-13 9:25 
QuestionIdentify DML changes between two databases Pin
Member 313707830-Jan-13 21:56
memberMember 313707830-Jan-13 21:56 
AnswerRe: Identify DML changes between two databases Pin
Mycroft Holmes30-Jan-13 22:11
memberMycroft Holmes30-Jan-13 22:11 
GeneralRe: Identify DML changes between two databases Pin
Member 313707830-Jan-13 22:26
memberMember 313707830-Jan-13 22:26 
QuestionUpdate a flag based on portion of data avialble in other column Pin
yuvachandra30-Jan-13 11:20
memberyuvachandra30-Jan-13 11:20 
AnswerRe: Update a flag based on portion of data avialble in other column Pin
Mycroft Holmes30-Jan-13 12:56
memberMycroft Holmes30-Jan-13 12:56 
GeneralRe: Update a flag based on portion of data avialble in other column Pin
yuvachandra31-Jan-13 7:08
memberyuvachandra31-Jan-13 7:08 
GeneralRe: Update a flag based on portion of data avialble in other column Pin
Mycroft Holmes31-Jan-13 12:32
memberMycroft Holmes31-Jan-13 12:32 
GeneralRe: Update a flag based on portion of data avialble in other column Pin
yuvachandra31-Jan-13 12:45
memberyuvachandra31-Jan-13 12:45 
GeneralRe: Update a flag based on portion of data avialble in other column Pin
yuvachandra1-Feb-13 8:00
memberyuvachandra1-Feb-13 8:00 
Questionhow to comlex databinding with access database Pin
Achilles8430-Jan-13 9:48
memberAchilles8430-Jan-13 9:48 
AnswerRe: how to comlex databinding with access database Pin
Mycroft Holmes30-Jan-13 12:49
memberMycroft Holmes30-Jan-13 12:49 
GeneralRe: how to comlex databinding with access database Pin
Achilles8430-Jan-13 21:49
memberAchilles8430-Jan-13 21:49 
GeneralRe: how to comlex databinding with access database Pin
Mycroft Holmes30-Jan-13 22:06
memberMycroft Holmes30-Jan-13 22:06 
GeneralRe: how to comlex databinding with access database Pin
Achilles841-Feb-13 1:25
memberAchilles841-Feb-13 1:25 
QuestionEnd Case in a Variable Pin
berba30-Jan-13 9:47
memberberba30-Jan-13 9:47 

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
Web04 | 2.8.160208.1 | Last Updated 9 Feb 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid