Click here to Skip to main content
11,483,003 members (70,656 online)
   

Database

 
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 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web03 | 2.8.150520.1 | Last Updated 22 May 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid