Chandler

导航

随笔分类 -  SQL

使用游标在存储过程中循环遍历数据
摘要：CREATEPROCEDUREupdatecountASDECLARE@flashID intDECLAREfavCountsCURSORLOCALSCROLLFORSELECTflashID FROMflashs_FavoritesOPENfavCountsFETCHNEXTFROMfavCountsINTO@flashIDWHILE @@FETCH_STATUS = 0BEGINupdatef... 阅读全文

posted @ 2009-05-06 17:19 Chandler.C 阅读(529) 评论(0) 推荐(0)