How to write code in sql to avoid duplicate records while inserting

Question

0.00/5 (No votes)

See more:

Hi, I am a not much aware of sql so please help me ,I need to avoid duplicate records while inserting a table in sql

Here is my code below

ALTER procedure [dbo].[sp_InsertBankName]
(
@bankname as varchar(50)
,@banknamea as nvarchar(50)
)
as
begin
declare @bankid as varchar(10)
select @bankid=isnull(max(convert(int,bankid)),0)+1 from bankname
insert into bankname
(bankid,bankname,banknamea)
values (@bankid,@bankname,@banknamea)
end

Posted 1-May-13 21:01pm

ManojMurali

Add a Solution

3 solutions

Solution 2

In Table bankname ,
set BankId as PrimaryKey And AutoIncreament

then write query...

SQL

ALTER procedure [dbo].[sp_InsertBankName]
 (
 @bankname as varchar(50)
 ,@banknamea as nvarchar(50)
 )
 as
 begin
     insert into bankname (bankname,banknamea)
                    values(@bankname,@banknamea)
 end

Happy Coding!
:)

Posted 1-May-13 21:12pm

Aarti Meswania

Solution 3

SQL

ALTER procedure [dbo].[sp_InsertBankName]
(
@bankname as varchar(50)
,@banknamea as nvarchar(50)
)
as
begin
IF EXISTS(SELECT bankid FROM bankname WHERE BankName=bankname )
AS BEGIN
<return any="" message="">
END
ELSE
BEGIN
declare @bankid as varchar(10)
select @bankid=isnull(max(convert(int,bankid)),0)+1 from bankname
insert into bankname
(bankid,bankname,banknamea)
values (@bankid,@bankname,@banknamea)
END
end</return>

Posted 1-May-13 21:18pm

ramrakshamishra

Comments

ManojMurali 2-May-13 6:03am

While i tried the above code its getting error

Msg 195, Level 15, State 10, Procedure sp_InsertBankName, Line 14
'message' is not a recognized built-in function name.

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)

Code-Hunt · Accepted Answer · 2013-05-01T21:07:00

Solution 1

u can try something similar to this

SQL

DECLARE @Count int

	SELECT @Count = Count(AutoID) FROM UserTable WHERE UserName = @userName

	IF @Count = 0

		BEGIN

			INSERT INTO UserTable (UserName) VALUES (@userName)

		END

Posted 1-May-13 21:07pm

Code-Hunt

Comments

ManojMurali 2-May-13 6:20am

Its working ok but how to show message that it already exists

[no name] 2-May-13 6:23am

That u have to do through your c#/vb.net coding..and if my solutions worked please accept that for future reference..
Thanks

ManojMurali 2-May-13 6:31am

Thanks Dude @

[no name] 2-May-13 6:37am

u r welcome..