lingfeng 发表于 2008-4-18 18:36:12

大家帮忙看看1299数据库里有没有这个2个存储过程

大家帮忙看看1299数据库里有没有这个2个存储过程
LOAD_PREMIUM_SERVICE_USER
UPDATE_WAREHOUSE_PW

有的麻烦发上来，我先谢过了，hoho

[ 本帖最后由 lingfeng 于 2008-4-18 18:38 编辑 ]

709394 发表于 2008-4-18 19:09:55

都需要呢,哪都没有

hl8882 发表于 2008-9-9 00:58:18

我有需要的加我QQ807555030

kentjy 发表于 2008-9-9 18:26:12

这两个是有的.一个是更新会员,一个是更新仓库储存的.会员的不用也可以:D

yfndq 发表于 2008-9-9 19:18:51

有的人就发一下吧 或者传到群上去

yangwx 发表于 2008-9-9 19:53:27

CREATE PROCEDURE LOAD_PREMIUM_SERVICE_USER
@AccountID varchar(27),
@nRet1 smallint OUTPUT,
@nRet2 smallint OUTPUT
AS
DECLARE @nRow smallint
SET @nRow = 0
DECLARE @Type smallint
SET @Type = null
DECLARE @Days smallint
SET @Days = null
SELECT @nRow = COUNT(*) FROM PREMIUM_SERVICE WHERE strAccountID = @AccountID
IF @nRow = 0
BEGIN
SET @nRet1 = 0 --Fail (Account don´t have premium service)
SET @nRet2 = 0 --Fail (Account don´t have premium service)
RETURN
END
BEGIN TRAN
SELECT @Type = strType, @Days = nDays FROM PREMIUM_SERVICE WHERE strAccountID = @AccountID
IF @Days = 0
BEGIN
DELETE FROM PREMIUM_SERVICE WHERE strAccountID = @AccountID
SET @nRet1 = 0 --Fail (Account don't have more premium days)
SET @nRet2 = 0 --Fail (Account don't have more premium days)
RETURN
END
COMMIT TRAN
SET @nRet1 = @Type
SET @nRet2 = @Days
GO
=======================
CREATEPROCEDURE .
        @accountid                 varchar(21),
        @WarehousePassword        varchar(17),
        @Money                int,
        @dwTime                int,
        @strItem                varchar(1600),
        @strSerial                varchar(1600)
AS
IFDATALENGTH(@WarehousePassword) < 6 OR @WarehousePassword IS NULL
        BEGIN
                SET @WarehousePassword = '000000'
        END
UPDATE        WAREHOUSE
Set
        nMoney                = @Money,
        dwTime                = @dwTime,
        WarehouseData        = @strItem,
        strSerial                = @strSerial,
        strWarehousePW=@WarehousePassword
WHERE        strAccountID        = @accountid
GO
页: [1]
查看完整版本: 大家帮忙看看1299数据库里有没有这个2个存储过程