ALTER PROCEDURE [dbo].[Tuan_TravelsInfo_MinusMaxNum]
@TuanTravelsInfoPKId int,
@MaxNum int
AS
DECLARE @Num int
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
BEGIN TRAN
UPDATE [Tuan_TravelsInfo] SET
[MaxNum]=[MaxNum]-@MaxNum
where TuanTravelsInfoPKId=@TuanTravelsInfoPKId
select @Num=[MaxNum] from [Tuan_TravelsInfo]
where TuanTravelsInfoPKId=@TuanTravelsInfoPKId
if @Num>=0
BEGIN
return 0;
END
ELSE
BEGIN
RETURN -1
ROLLBACK TRAN
END
END下面是调用
exec Tuan_TravelsInfo_MinusMaxNum 5,30
都不合适啊 哪位好心人帮忙看下啊
@TuanTravelsInfoPKId int,
@MaxNum int
AS
DECLARE @Num int
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
BEGIN TRAN
UPDATE [Tuan_TravelsInfo] SET
[MaxNum]=[MaxNum]-@MaxNum
where TuanTravelsInfoPKId=@TuanTravelsInfoPKId
select @Num=[MaxNum] from [Tuan_TravelsInfo]
where TuanTravelsInfoPKId=@TuanTravelsInfoPKId
if @Num>=0
BEGIN
return 0;
END
ELSE
BEGIN
RETURN -1
ROLLBACK TRAN
END
END下面是调用
exec Tuan_TravelsInfo_MinusMaxNum 5,30
都不合适啊 哪位好心人帮忙看下啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货