2009年5月6日随笔档案 - Chandler.C

2009年5月6日 #

使用游标在存储过程中循环遍历数据

CREATE PROCEDURE updatecount AS

DECLARE @flashID int

DECLARE favCounts CURSOR LOCAL SCROLL FOR

SELECT flashID FROM flashs_Favorites

OPEN favCounts

FETCH NEXT FROM favCounts INTO @flashID
WHILE @@FETCH_STATUS = 0

BEGIN

update flashs_flashs set favCount=favcount + 1 where flashID=@flashID

FETCH NEXT FROM favCounts INTO @flashID

END

CLOSE favCounts

DEALLOCATE favCounts

posted @ 2009-05-06 17:19 Chandler.C 阅读(152) 评论(0) 编辑