ALTER PROCEDURE [dbo].[TCreateTable] @
[Only registered and activated users can see links. Click Here To Register...]ewTable as NVARCHAR(50)
AS
DECLARE @
[Only registered and activated users can see links. Click Here To Register...]QL NVARCHAR(1200)
BEGIN
SET @
[Only registered and activated users can see links. Click Here To Register...]QL = 'CREATE TABLE [dbo].[' + @
[Only registered and activated users can see links. Click Here To Register...]ewTable + '] (
[LT_SEQ] bigint NOT NULL IDENTITY(1,1) ,
[LT_LOGDATE] varchar(50) NULL ,
[LT_SERVERID] varchar(50) NULL ,
[LT_CLIENTIP] varchar(50) NULL ,
[LT_ACTION] int NULL ,
[LT_MAPID] int NULL ,
[LT_X] real NULL ,
[LT_Y] real NULL ,
[LT_Z] real NULL ,
[LT_DWKEY1] bigint NULL ,
[LT_DWKEY2] bigint NULL ,
[LT_DWKEY3] bigint NULL ,
[LT_DWKEY4] bigint NULL ,
[LT_DWKEY5] bigint NULL ,
[LT_DWKEY6] bigint NULL ,
[LT_DWKEY7] bigint NULL ,
[LT_DWKEY8] bigint NULL ,
[LT_DWKEY9] bigint NULL ,
[LT_DWKEY10] bigint NULL ,
[LT_DWKEY11] bigint NULL ,
[LT_KEY1] varchar(255) NULL ,
[LT_KEY2] varchar(255) NULL ,
[LT_KEY3] varchar(255) NULL ,
[LT_KEY4] varchar(255) NULL ,
[LT_KEY5] varchar(255) NULL ,
[LT_KEY6] varchar(255) NULL ,
[LT_KEY7] varchar(255) NULL ,
[LT_FMT] int NULL ,
[LT_LOG] varchar(255) NULL
)
ALTER TABLE [dbo].[' + @
[Only registered and activated users can see links. Click Here To Register...]ewTable + '] ADD PRIMARY KEY ([LT_SEQ])'
EXECUTE @
[Only registered and activated users can see links. Click Here To Register...]QL)
END