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