Your technology certification is waiting. Enroll in Cloud Class ®
The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
Drop TABLE CSVTest
CREATE TABLE CSVTest
Drop TABLE CSVtemp
CREATE TABLE CSVtemp
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
--Check the existing data of the table and insert new records.
Insert into CSVTest SELECT *
FROM CSVtemp Where [ID] Not In (Select [ID] from CSVTest)
--Select the main table.
Open in new window
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.