+ϩ

来自「介绍了数据库方面的基础知识」· 代码 · 共 15 行

作者：Ray
email: [e-mail]
日期：00-3-24 下午 11:00:25
declare <cursor_name> scroll cursor for
    select <fields_list> from <tables_list> where <conditions>
open <cursor_name>
fetch absolute N+1 from <cursor_name> into <vars_list>
while @@fetch_status=0
    begin
        insert <another_table> (<fields_list>) values (<vars_list>)
        fetch next from <cursor_name> into <vars_list>
    end
close <cursor_name>
decllocate <cursor_name>