CREATE PROCEDURE prct_goods(@goodsId varchar(40),@goodsName varchar(100))
AS
declare @ifExist int
set @goodsId = left(@goodsId,20)
set @goodsName = left(@goodsName,60)
set @ifExist=( select count(*) from prcc_goods where wareid=@goodsid)
if @ifExist = 0
begin
insert into prcc_goods
values (@goodsId,@goodsName)
end
else
begin
update prcc_goods
set warename=@goodsName
where wareid=@goodsId
end