求助SQL储存过程
来源:百度知道 编辑:UC知道 时间:2024/06/10 06:21:18
这个帮忙注释下...
ALTER PROCEDURE [dbo].[usp_Read_User_CashPoint_PayLetterT]
@CashPoint int OUTPUT,
@UserUID int
AS
SET NOCOUNT ON
SET @CashPoint = 0
SELECT @CashPoint=ISNULL(Point,0) FROM game.PS_UserData.dbo.Users_Master WHERE UserUID=@UserUID
IF @CashPoint < 0
BEGIN
UPDATE game.PS_UserData.dbo.Users_Master SET Point=0 WHERE UserUID=@UserUID
SET @CashPoint = 0
END
SET NOCOUNT OFF
ALTER PROCEDURE [dbo].[usp_Read_User_CashPoint_PayLetterT]
@CashPoint int OUTPUT,
@UserUID int
AS
SET NOCOUNT ON
SET @CashPoint = 0
SELECT @CashPoint=ISNULL(Point,0) FROM game.PS_UserData.dbo.Users_Master WHERE UserUID=@UserUID
IF @CashPoint < 0
BEGIN
UPDATE game.PS_UserData.dbo.Users_Master SET Point=0 WHERE UserUID=@UserUID
SET @CashPoint = 0
END
SET NOCOUNT OFF
ALTER PROCEDURE [dbo].[usp_Read_User_CashPoint_PayLetterT]
@CashPoint int OUTPUT,
@UserUID int
AS
SET NOCOUNT ON
--关闭行数统计
SET @CashPoint = 0
--赋值@CashPoint 为0
SELECT @CashPoint=ISNULL(Point,0) FROM game.PS_UserData.dbo.Users_Master WHERE UserUID=@UserUID
--从PS_UserData.dbo.Users_Master查询UserUID为=@UserUID的 Point列并把Point的值给变量
@CashPoint
IF @CashPoint < 0
--如果@CashPoint 现在小于0就执行下面的UPDATE
BEGIN
UPDATE game.PS_UserData.dbo.Users_Master
SET Point=0 WHERE UserUID=@UserUID
--修改game.PS_UserData.dbo.Users_Master表里的UserUID=@UserUID的信息的
Point为0
SET @CashPoint = 0
END
SET NOCOUNT OFF