使用游标将一张表导入另一张表

    技术2025-03-07  56

    declare cursor_test8  cursor KEYSET forselect col001 from info

    open  cursor_test8FETCH FIRST from cursor_test8declare @k varchar(40)while (@@fetch_status =0)beginfetch  next from cursor_test8 into @kinsert into info2 values(@k)endclose cursor_test8

    最新回复(0)