Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
44
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. "INSERT IGNORE INTO DataBase.Table
  2. (OrderNumber, CCHolder, CCPartial, CCEci, CCTransDate,
  3. CCPmtRef,CCStatus,CCMaster) " +
  4. "VALUES (@orderNumber, @CCholder,
  5. @CCpartial, @CCeci, @CCtransDate, @CCpmtRef, @CCstatus,
  6. @CCmaster) " +
  7. "WHERE @CCmaster NOT EXISTS (SELECT CCMaster FROM
  8. DataBase.Table)";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement