【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“TypeUp.sql”一文,供大家参考学习!
use BuyGoods
go
if object_id('dbo.TypeUpgrate') is not null
drop procedure dbo.TypeUpgrate
go
create procedure TypeUpgrate
@type char(10)=null
as
begin
if not exists(select * from TypeList where type=@type)
insert into TypeList(type)values(@type)
if(@@error<>0)
print('update error!')
return
end
go