【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“proc_insertCheck.sql”一文,供大家参考学习!
use db_SMS
go
if object_Id('proc_insertCheck') is not null
drop proc proc_insertCheck
go
create proc proc_insertCheck
(
@GoodsID bigint,
@StoreName varchar(100),
@GoodsName varchar (50),
@GoodsUnit char (8),
@CheckNum bigint,
@PALNum bigint,
@CheckPeople varchar (20),
@CheckRemark varchar (1000)
)
as
if exists(select * from tb_Check where GoodsID=@GoodsID)
begin
return 100
end
else
begin
insert into tb_Check(GoodsID,StoreName,GoodsName,GoodsUnit,CheckNum,PALNum,CheckPeople,CheckRemark)
values(@GoodsID,@StoreName,@GoodsName,@GoodsUnit,@CheckNum,@PALNum,@CheckPeople,@CheckRemark)
end
go