SQLServer游标使用方法
摘要：
declare @BizNo varchar(30)declare OrderID cursor for select TruckNo from FT_Truck where Supplier='' and OccurDate between '2010-12-03' and getdate() open OrderID; fetch OrderID into @BizNo; while(@@FETCH_STATUS=0) begin EXEC [TF_Cala_Order_Cost_AP_SP] @ACTIONTYPE='Cala_Appl_Quotation_A 阅读全文
posted @ 2011-01-27 19:08 nick轩 阅读(208) 评论(0) 推荐(0) 编辑