declare @F_Money varchar(30)
declare Cur1_Bill cursor for
select b.F_Money from "Table"
open Cur1_Bill
fetch next from Cur1_Bill into @F_Money
close Cur1_Bill
deallocate Cur1_Bill
@F_Money 就是在数据表Table中取出的值可以在存储过程中使用。
declare @F_Money varchar(30)
declare Cur1_Bill cursor for
select b.F_Money from "Table"
open Cur1_Bill
fetch next from Cur1_Bill into @F_Money
close Cur1_Bill
deallocate Cur1_Bill
@F_Money 就是在数据表Table中取出的值可以在存储过程中使用。