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>