create table SM_User(Usercode varchar(10),UserName varchar(10),[Password] varchar(10))
go
create proc [insert]
@Usercode varchar(10),
@UserName varchar(10),
@Password varchar(10)
as
if(@Usercode is not NULL)
begin
if not exists(select 1 from SM_User where Usercode=@Usercode)
begin
insert into SM_User values(@Usercode,@UserName,@Password)
end
else
begin
raiserror('已经存在该Usercode的记录!',16,1)
end
end
else
begin
raiserror('Usercode不能为NULL!',16,1)
end
go