sqlserver 删除表的同时取出数据（类似触发器）

DROP TABLE #AACREATE TABLE #AA(ID INT,NAME VARCHAR(50))INSERT INTO #AASELECT 1,'AAA' UNION ALLSELECT 2,'BBB' UNION ALLSELECT 3,'CCC' UNION ALLSELECT 4,'DDD'select * from #AADROP TABLE #AA_DELETEEDSELECT * INTO #AA_DELETEED FROM #AA WHERE 1=2Delete #AA  --将删除表#AA所有的记录output deleted.NAME --取想要的列into #AA_DELETEED(NAME) --插入到另一个表中--where ID<3  --此条件是约束删除的条件,不是插入到另一个表的约束条件select * from #AA  --数据清空select * from #AA_DELETEED  --NAME 列有数据