How to check if there's an item at Sql Server Table

[rgparisoto]

Hi guys!

I'm importing an XML file that has a code.

I need to find at a SQL Server table if this code exist or not, if exist, do nothing, if do not exist, insert.

I made a SQL query to count if this code exist, but, when do not exist, I can't made any solution do continue the flow.

Has someone that made some solution like this?

Thank you,

Robson.

[barret · Accepted solution]

I would do this all in a single SQL statement. Something to the effect of:

IF NOT EXISTS (SELECT TOP 1 * FROM TABLENAME WHERE CODE = 'CODE')

INSERT INTO TABLENAME VALUES ('CODE')

No need to have multiple steps do anything else.

[rgparisoto]

Thank you @barret !

I'll test.

Regards,

Robson.