首页 › KO技术综合区「KO. PROGRAM」 › COUPON_EVENT 存储及表格

ctgwglzc 发表于 2009-9-22 01:55:47

COUPON_EVENT 存储及表格

/****** Object:Table .    Script Date: 08/29/2009 05:21:42 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE .(
(21) NOT NULL,
(21) NOT NULL,
(20) NOT NULL,
NOT NULL,
NOT NULL,
NOT NULL,
CONSTRAINT PRIMARY KEY CLUSTERED
(
ASC
)WITH (PAD_INDEX= OFF, STATISTICS_NORECOMPUTE= OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS= ON, ALLOW_PAGE_LOCKS= ON) ON
) ON

GO

SET ANSI_PADDING ON
GO

ALTER TABLE . ADDCONSTRAINT DEFAULT (getdate()) FOR
GO

ctgwglzc 发表于 2009-9-22 01:55:58

/****** Object:Table .    Script Date: 08/29/2009 05:22:28 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE .(
NOT NULL,
(16) NOT NULL,
NOT NULL,
NOT NULL
) ON

GO

SET ANSI_PADDING ON
GO

ctgwglzc 发表于 2009-9-22 01:56:17

CREATE PROCEDURE .
@strAccountIDchar(21),
@strCouponIDchar(21),
@nRetsmallint OUTPUT

AS

DECLARE @Row tinyint

SELECT @Row = COUNT(AccountID) FROM COUPON_EVENT WHERE CouponID = @strCouponID ORAccountID = @strAccountID

IF @Row = 0
BEGIN
SET @nRet =0
RETURN
END

SET @nRet =1CREATE PROCEDURE .
@strAccountIDchar(21),
@strCharID char(21),
@strCouponID char(20),
@nItemIDint,
@nItemCountint

AS

BEGIN TRAN
INSERT INTO COUPON_EVENT (AccountID, CharID, CouponID, ItemID, ItemCount )
VALUES(@strAccountID, @strCharID, @strCouponID, @nItemID, @nItemCount )

COMMIT TRAN

yangwx 发表于 2009-9-22 12:42:26

本帖最后由 yangwx 于 2009-9-22 12:50 编辑

都是干啥用滴？？？？？代码似乎不全。

ctgwglzc 发表于 2009-9-22 18:06:10

公服的COUPON活动

查看完整版本: COUPON_EVENT 存储及表格