Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Aug 16, 2012 03:34 PM by inquisitive_mind
Aug 16, 2012 10:45 AM|LINK
I am using sqlbulkcopy to insert thousond of record from xls to DB.
The problem is how i do avoid duplicates values??
for this i dont want to use extra table or any other trigger or identity column...
is ther any other way to do this????
Aug 16, 2012 03:34 PM|LINK
Use the "not exists" clause of the select statement in your insert statement to the table.
Take a look at this link it has examples of how to use insert and not exists