一个简单sql触发器 循环查询添加

个简单的查询循环添加SQL语然希望对大家有得帮助

DECLARE @id int, @i int, @count int
SET @i = 1
WHILE @i < 7454
BEGIN
SELECT @id = id FROM Sam_Users WHERE id = @i
if(@id!='')
INSERT INTO Sam_UserOperate(UserID, Mark, Template_Old, Template_New) VALUES (@id, 0, '粉红回忆', '粉红回忆')
set @i=@i+1
END

转载于:https://www.cnblogs.com/xiachufeng/archive/2010/06/25/1765533.html