DECLARE POSDTLBIN_CUR CURSOR LOCAL FAST_FORWARD FOR SELECT
[Pri_acct_num_val],
[Amount_of_txn],
[Ib_code],
[Txn_code],
[From_type]
FROM POSDTLTEMP WHERE DATE_OF_SLMT=@CURDATE
and txn_code='0113' ***********这儿是重点**********
FOR READ ONLY
-->DECLARE POSDTLBIN_CUR CURSOR LOCAL FAST_FORWARD FOR SELECT
[Pri_acct_num_val],
[Amount_of_txn],
[Ib_code],
[Txn_code],
[From_type]
FROM POSDTLTEMP WHERE DATE_OF_SLMT=@CURDATE
order by txn_code -- ***********这儿是重点**********
FOR READ ONLY
[Pri_acct_num_val],
[Amount_of_txn],
[Ib_code],
[Txn_code],
[From_type]
FROM POSDTLTEMP WHERE DATE_OF_SLMT=@CURDATE
and txn_code='0113' ***********这儿是重点**********
FOR READ ONLY
-->DECLARE POSDTLBIN_CUR CURSOR LOCAL FAST_FORWARD FOR SELECT
[Pri_acct_num_val],
[Amount_of_txn],
[Ib_code],
[Txn_code],
[From_type]
FROM POSDTLTEMP WHERE DATE_OF_SLMT=@CURDATE
order by txn_code -- ***********这儿是重点**********
FOR READ ONLY
可惜,我搜索到那两个贴了,都是2003年1-3月的,但是都打不开,csdn真实该死。zjcxc(邹建) 版主:版主是不是能重新产生历史贴?