Before insert check if record exists?

Question

User-1104215994 posted

Hi guys,

I have a console app and I am retrieving data from an API every 2 hours. I would like to insert data if only new into this table but I wonder if there is a way to check data before inserting into table. If I have over 100 records every fetch from this API and I don't want to manually check one record at a time to see if data in a certain column already exist, how do I write the query to check if data in my records already exist before inserting?

Thanks in advance.

Answer 1

User475983607 posted

You did not share the code so we can only guess.  The following is basic T-SQL.

IF( NOT EXISTS(SELECT (1) FROM [Production].[Product] WHERE [ProductNumber] = 'AR-5382'))
BEGIN
	print 'Does not exist'
END

Answer 2

User-1104215994 posted

I will get these data below from the API;

id, customerId, firstName, lastName, phone, productCode, orderDate (unix epoch time)

I will use raw SQL in my app, it's much simpler for me.