给每条记录的时间增加随机秒数

DECLARE @RecommendID INT
DECLARE @SECOND INT
DECLARE @Index int
set @Index = 1     


 declare cur_recommendfriend cursor for
SELECT RecommendID FROM T_Mem_RecommendFriends


Begin  Tran


open cur_recommendfriend
fetch next from cur_recommendfriend into @RecommendID
while (@@fetch_status=0)
  begin
SET @SECOND=round(rand()*60,0)
print '@Index:'+cast(@Index as varchar) +'-----'+'@SECOND:'+cast(@SECOND as varchar)

--print 
UPDATE T_Mem_RecommendFriends SET RecommendDate=DATEADD(ss,@SECOND,RecommendDate)  
WHERE RecommendID=@RecommendID


         set @Index = @Index+1
    fetch next from cur_recommendfriend into @RecommendID
end
close cur_recommendfriend
deallocate cur_recommendfriend


Commit Tran


if @@error>0
BEGIN
ROLLBACK
END