游标示例

< DOCTYPE html PUBLIC -WCDTD XHTML StrictEN httpwwwworgTRxhtmlDTDxhtml-strictdtd>

DECLARE titles_cursor CURSOR FOR select distinct E_ID from C_Employee order by E_ID ASC ;

declare @ids as varchar(1000)

OPEN titles_cursor

declare @iname as int

FETCH NEXT FROM titles_cursor INTO @iname

WHILE @@FETCH_STATUS = 0

BEGIN

   select top 10 * from c_monthattendance where

END

CLOSE titles_cursor

deallocate titles_cursor

本文转自 netcorner 博客园博客，原文链接： http://www.cnblogs.com/netcorner/archive/2009/10/17/2912056.html  ，如需转载请自行联系原作者