Check for the Duplicates

[ganeshkumar08]

Hi SQL friends,

I friends i need to check whether the record is already available..
ie. Before Inserting and Updating which are the validations to be done.

I need a standard solution for this.

Using SELECT and WHERE clause we can able to check for the availability, but i need a standard which are followed in the company.

Can any one you please send me the query.

Thanks and Regards
Ganesh kumar V

[code green]

The easiest way is to deny duplicates in the table settings.
But I am not sure what you are getting at.

[amitpatel66]

Hi SQL friends,

I friends i need to check whether the record is already available..
ie. Before Inserting and Updating which are the validations to be done.

I need a standard solution for this.

Using SELECT and WHERE clause we can able to check for the availability, but i need a standard which are followed in the company.

Can any one you please send me the query.

Thanks and Regards
Ganesh kumar V

Create a BEFORE INSERT OR UPDATE TRIGGER on a table to check if the data that is inserted already exist?
If yes, then do an UPDATE, else INSERT the new record in to database.

[ganeshkumar08]

Create a BEFORE INSERT OR UPDATE TRIGGER on a table to check if the data that is inserted already exist?
If yes, then do an UPDATE, else INSERT the new record in to database.

In SQL Server BEFORE INSERT OR UPDATE TRIGGER is available?
If available means can u give me a sample code..

[ck9663]

Read more here

-- CK