SqlBulkCopy Tutorial - Knowledge Base (KB)

How to skip same duplicate key data when copy table

I have a table1(key is X, XX) looks like below:...x,y,xx,yy,xxx,yyy ...I created a new table2 (key is code) as below:...code,name,xx,yy,xxx,yyy ...Now I wan to copy all data in table1 to table2, and if met same code skip it, ...x -> code Y -> name xx-> xx...