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
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)
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