第1个回答 2010-11-22
用游标实现!
declare cursor_name cursor for select column1,column2,from table1 where 。。。
declare @col1 column1_type
declare @col2 column2_type
open cursor_name
WHILE @@FETCH_STATUS = 0
begin
fetch next from cursor_name into @col1,@col2
insert table2(column_name1,column_name2) values(@col1,@col2)
end
close cursor_name