sql equivelent of Insert Ignore
Posted on 2010-11-18
sorry, I saw angellll response to this question but I guess I need further clarification. Using MSSQL 2005, I want to execute the following command and have it ignore duplicate key values:
Insert Into "Sample Database".dbo."customer notes"
("Customer ID", "Note Date", Text)
Select "Customer ID", "Noted Date", Text
From "Test Database".dbo."customer notes"
The customer ID has duplicate values, but I want to ignore this. What specifically is the syntax of the SQL statement?