执行带输出参数的存储过程

 declare @msg varchar(100)
exec [submitinfo] '','','','','','','','','','','','','','34342','90782528352907',0,1,'kf01',@msg output
select @msg

 

@msg 为返回的信息

 

存储过程一部分:

ALTER proc [dbo].[submitinfo]
(
@Name varchar(20),
@Phone varchar(20),
@Telephone varchar(20),
@UserAddress varchar(100),
@WangID varchar(30),
@UserMessage varchar(200),
@Memo varchar(300),
@ZipCode int,
@RegisName varchar(30),
@RegisPhone varchar(30),
@Diver varchar(30),
@ShopName varchar(40),
@PlanTime datetime,
@LongCardID varchar(30),
@TaoID varchar(40),
@istaoid bit,
@iscardid bit,
@infosource varchar(40),
@ts varchar(100) output
)
as
 if(select COUNT(*) from UserInfo where LongCardID=@LongCardID andTaoID=@TaoID)=1
    begin
     set @ts='您的订单已提交,请勿重复提交,详情请致电400-000-3088!'
    return
    end