B*****g 发帖数: 34098 | 1 一个procedure, 是用第一种方法好,还是第二种(id 是table的pk,unique index?
为什么? 谢谢
1.
select rowid,....
into lnRowi1d, ......
from tab1
something between
update tab1
set .....
where rowid = lnRowi1d
2.
select id,....
into lnId, ......
from tab1
something between
update tab1
set .....
where id = lnId |
|