SQL Server 2005数据库系统开发与实例读书摘要（戴志诚 编著，2007.3）

chap8 索引和游标
declare @userid int
DECLARE XM_cursor cursor for select UserID from [qpaccountsdb].[dbo].[AccountsInfo]
open XM_cursor
FETCH NEXT FROM XM_cursor into @userid

WHILE(@@FETCH_STATUS=0)
BEGIN
--print @userid
--EXEC qptreasuredb.[dbo].[SendCompensationMail] @userid
FETCH NEXT FROM XM_cursor into @userid
END
CLOSE XM_cursor
DEALLOCATE XM_cursor