34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER trigMoveData
ON t1
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;
IF (select COUNT(0) FROM t1)=1000
BEGIN
IF OBJECT_ID('tt') IS NULL
BEGIN
SELECT * INTO t11 FROM t1
END
ELSE
BEGIN
INSERT INTO t11 SELECT * FROM t1
END
TRUNCATE TABLE t1
END
END
GO