表 bankname ，

将 BankId 设为 PrimaryKey 和 AutoIncreament



然后写查询...

  ALTER   procedure  [dbo]。[sp_InsertBankN ame] 
（
 @ bankname   as   varchar （ 50 ）
， @ banknamea   as   nvarchar （ 50 ）
）
 as  
 begin  
 插入 到 bankname（bankname，banknamea） 
 值（ @ bankname ， @ banknamea ） 
结束 

快乐编码！

：）

  ALTER   procedure  [dbo]。[sp_InsertBankName] 
 （
 @ bankname   as   varchar （ 50 ）
， @ banknamea   as   nvarchar （ 50 ）
）
 as  
开始 
 IF   EXISTS （ SELECT  bankid  FROM  bankname  WHERE  BankName = bankname）
 AS   BEGIN  
&lt ; return any =   message =  > 
 END  
 ELSE  
 BEGIN  
声明  @ bankid   as   varchar （ 10 ）
选择 @ bankid = isnull（max（ convert （ int ，bankid）） ， 0 ）+ 1 来自 bankname 
 insert   into  bankname 
（bankid，bankname，banknamea）
值 （ @ bankid ， @ bankname ， @ banknamea ）
 END  
 end< / return> 

u ca尝试类似的东西

  DECLARE   @ Count   int  

 SELECT   @ Count  = Count（AutoID） FROM  UserTable  WHERE  UserName =  @ userName  

 IF   @Count  =  0  

 BEGIN  

 INSERT   INTO  UserTable（UserName） VALUES （ @ userName ）

 END  

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

In Table bankname ,
set BankId as PrimaryKey And AutoIncreament

then write query...

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!
:)

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>

u can try something similar to this

DECLARE @Count int

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

	IF @Count = 0

		BEGIN

			INSERT INTO UserTable (UserName) VALUES (@userName)

		END