使用游标在存储过程中循环遍历数据
摘要:
CREATEPROCEDUREupdatecountASDECLARE@flashID intDECLAREfavCountsCURSORLOCALSCROLLFORSELECTflashID FROMflashs_FavoritesOPENfavCountsFETCHNEXTFROMfavCountsINTO@flashIDWHILE @@FETCH_STATUS = 0BEGINupdatef... 阅读全文
posted @ 2009-05-06 17:19 Chandler.C 阅读(522) 评论(0) 推荐(0) 编辑