How can i put a check for while inserting duplicate value into table

Question

3.00/5 (2 votes)

See more:

I have a Work_Details table containing
Work_Name

intigrated
stringvalue
CharValue

Now I need a query that will return something if I give duplicate name.
Means if I give CharValue again it will not insert in the table.
How can I put a check before inserting in to the table?

Posted 7-Mar-13 23:16pm

sasen903

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jonathan [Darka] · Answer 1 · 2013-03-07T23:19:00

Solution 1

You don't need to check before the INSERT.

Make one of the fields a unique key, then when you attempt to INSERT into the database it will fail telling you that that record already exists.

Posted 7-Mar-13 23:19pm

Jonathan [Darka]

Updated 7-Mar-13 23:20pm

v3

Comments

sasen903 8-Mar-13 5:54am

The table should not have any Primary Key.
I just need to return a value(suppose using count()) that will say if the value exists in the table or not.
And i will check using the value

jay narayan · Answer 2 · 2013-03-07T23:33:00

Solution 2

SQL

if not exists ( select * from table  where field=value)
begin
put insert query 
end

and if want to see dublicate row

use

like

select count(*) from table group by (column name ) having count(*)>1

it will all dulicate record

Posted 7-Mar-13 23:33pm

jay narayan

Comments

sasen903 8-Mar-13 5:56am

How the Count will return a value if the data is existing in the table or not