【SQL开源代码栏目提醒】:网学会员--在 SQL开源代码编辑为广大网友搜集整理了:customer_up.sql绩等信息,祝愿广大网友取得需要的信息,参考学习。
use produce
go
if object_id('dbo.cust_up') is not null
drop procedure dbo.cust_up
go
create procedure cust_up
@customer varchar(30)=null
as
begin
if not exists(select * from cust_iqc)
insert into cust_iqc(customer)values(@customer)
if(@@error<>0)
print('Update Customer error!')
return
end
go