Question

sqlserver 存储过程中抛出异常

--------------证照到期拦截
if @djlxbs in ('1121','212','211','2121')
begin

---质保协议
/*if exists(select * from mchk where dwbh=@dwbh and zbxyyxq<convert(char(10),getdate(),21) and len(zbxyyxq)=10)
begin
set @return=7001
goto err_lab
end */
----许可证
if exists(select * from mchk where dwbh=@dwbh and xkzyxq<convert(char(10),getdate(),21) and len(xkzyxq)=10)
begin
set @return=7002
goto err_lab
end

Answer 1

程中抛出异常