ALTER Proc MoneyCard_Singal_Out
@MoneyCardTypeName varchar(20)
as
begin
--declare @Number varchar(20), @Pwd varchar(20)
declare @MoneyCardNo varchar(20),@MoneyCardPwd varchar(20)
select top 1 @MoneyCardNo=MoneyCard.MoneyCardNo, @MoneyCardPwd=MoneyCard.Pwd
from MoneyCard,MoneyCardType where MoneyCardType.CardTypeName=@MoneyCardTypeName and MoneyCardType.CardTypeID=MoneyCard.CardTypeID and MoneyCard.State=0
update MoneyCard set MoneyCard.State=4 where MoneyCard.MoneyCardNo=@MoneyCardNo
select @MoneyCardNo,@MoneyCardPwd
end
g0
@MoneyCardTypeName varchar(20)
as
begin
--declare @Number varchar(20), @Pwd varchar(20)
declare @MoneyCardNo varchar(20),@MoneyCardPwd varchar(20)
select top 1 @MoneyCardNo=MoneyCard.MoneyCardNo, @MoneyCardPwd=MoneyCard.Pwd
from MoneyCard,MoneyCardType where MoneyCardType.CardTypeName=@MoneyCardTypeName and MoneyCardType.CardTypeID=MoneyCard.CardTypeID and MoneyCard.State=0
update MoneyCard set MoneyCard.State=4 where MoneyCard.MoneyCardNo=@MoneyCardNo
select @MoneyCardNo,@MoneyCardPwd
end
g0
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货