| 本帖最后由 jianweis 于 2012-4-17 12:27 编辑 
 下载地址:复制代码/****** Object:  Table [dbo].[ITEM_LOG]    Script Date: 04/16/2012 21:32:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ITEM_LOG](
        [srcid] [varchar](50) NULL,
        [tarid] [varchar](100) NULL,
        [type] [int] NULL,
        [putserial] [bigint] NULL,
        [putitemid] [int] NULL,
        [money] [int] NULL,
        [putdure] [int] NULL,
        [putcount] [int] NULL,
        [getcount] [int] NULL,
        [uscroll] [int] NULL,
        [getitem] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  StoredProcedure [dbo].[INSERT_ITEM_LOG]    Script Date: 04/16/2012 21:32:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:                SJW
-- Create date: 2012-4-14
-- Description:        ItemManger
-- =============================================
CREATE PROCEDURE [dbo].[INSERT_ITEM_LOG]
@srcid varchar(50),
@tarid varchar(100),
@type int,
@putserial bigint,
@putitemid int,
@money int,
@putdure int,
@putcount int,
@getcount int,
@uscroll int,
@getitem int        
AS
BEGIN
insert into ITEM_LOG(srcid,tarid,type,putserial,putitemid,money,putdure,putcount,getcount,uscroll,getitem)
values(@srcid,@tarid,@type,@putserial,@putitemid,@money,@putdure,@putcount,@getcount,@uscroll,@getitem)
END
GO
5.rar
 |