22,210
社区成员
发帖
与我相关
我的任务
分享
--试试不换行go
INSERT INTO [DT_SQLDataList]([FOper], [FTableFrom], [FTableTo],
[FWhereSql], [FTime], [FSQL], [FIsGen], [FToUserNo], [FSqlType], [FBusTypeID],
[FWhereSQLA], [FItemType])
VALUES (1, N'*', N'*', NULL, NULL, N'if exists (select * from
dbo.sysobjects where id = object_id(N''[dbo].[DT_Log_Insert]'') and OBJECTPROPERTY(id, N''IsTrigger'') = 1)
drop trigger [dbo].[DT_Log_Insert] GO
CREATE TRIGGER [DT_Log_Insert] ON [dbo].[DT_Log]
FOR INSERT
AS
SET NOCOUNT ON
Declare @intRecNo Int
Declare @intMaxID Int
Select @intRecNo = Count(FID) From Dt_Log
if @intRecNo > 3000
Begin
SELECT @intMaxID = Max(FID) From Dt_Log
DELETE FROM Dt_Log Where FID < (@intMaxID - 3000)
End
SET NOCOUNT OFF GO', 1, N'-1', 1, 0, NULL, NULL)
create table dt_sqldatalist
([FOper] int,[FTableFrom] varchar(10), [FTableTo] varchar(10),
[FWhereSql] varchar(10), [FTime] datetime, [FSQL] text, [FIsGen] int,
[FToUserNo] int , [FSqlType] int, [FBusTypeID] int,
[FWhereSQLA] int, [FItemType] int)
go
INSERT INTO [DT_SQLDataList]([FOper], [FTableFrom], [FTableTo],
[FWhereSql], [FTime], [FSQL], [FIsGen], [FToUserNo], [FSqlType], [FBusTypeID],
[FWhereSQLA], [FItemType])
VALUES (1, N'*', N'*', NULL, NULL, N'if exists (select * from
dbo.sysobjects where id = object_id(N''[dbo].[DT_Log_Insert]'')
and OBJECTPROPERTY(id, N''IsTrigger'') = 1)
drop trigger [dbo].[DT_Log_Insert] go
CREATE TRIGGER [DT_Log_Insert] ON [dbo].[DT_Log]
FOR INSERT
AS
SET NOCOUNT ON
Declare @intRecNo Int
Declare @intMaxID Int
Select @intRecNo = Count(FID) From Dt_Log
if @intRecNo > 3000
Begin
SELECT @intMaxID = Max(FID) From Dt_Log
DELETE FROM Dt_Log Where FID < (@intMaxID - 3000)
End
SET NOCOUNT OFF GO'
, 1, N'-1', 1, 0, NULL, NULL)
drop table DT_SQLDataList