完全に備忘録。 use hoge go DECLARE @ID int DECLARE @targetdate datetime DECLARE CUR CURSOR LOCAL FOR SELECT ID FROM user.target OPEN CUR FETCH NEXT FROM CUR INTO @ID SET @targetdate = '2011-1-1' UPDATE user.target set target_field = @fromd…