关于SQL中的存储过程问题?
请高手帮忙解释一下,这个存储过程的功能是什么,以及每一部分的意思?我是新手,这方面不懂,帮忙解决,谢谢!
CREATE procedure xp_Service_DB
(
@OrgAddr varchar(21),
@OrgAddrType varchar(2),
@DestAddr varchar(21),
@ServiceCode varchar(20),
@Msg varchar(200),
@LinkID varchar(20),
@ReturnMsgID int output,
@ReturnFeeType int output,
@ReturnMsg varchar(200) output,
@Ret int output
)
AS
declare @Cnt int;
begin
set @Cnt = 0
select @Cnt=count(*) from msg where service = @ServiceCode
if @Cnt =0
begin
set @ReturnMsg='对不起,没有您点播的内容!';
end
else
begin
select top 1 @ReturnMsg = msg_neirong FROM msg WHERE service = @ServiceCode ORDER BY msg_id desc
end
exec xp_EasySendOneMessage @DestAddr,@OrgAddr,@ReturnMsg,@ServiceCode,'0',@OrgAddr,@LinkID
end;
GO