declare @name varchar(50)DECLARE cuTemp CURSOR FOR select 標志,縣市區 from mytable open cuTemp fetch cuTemp into @name, @dis while (@@fetch_status=0) begin if @name = 'b' insert into mytable1(mytable1.姓名)(mytable.姓名) if @dis = '廣東' insert into mytable1(mytable1.姓名,mytable1.縣市區)(mytable.姓名,mytable.縣市區) --这里是你的Insert语句 fetch cuTemp into @name, @dis end close cuTemp DEALLOCATE cuTemp
select 標志,縣市區 from mytable
open cuTemp
fetch cuTemp into @name, @dis
while (@@fetch_status=0)
begin
if @name = 'b'
insert into mytable1(mytable1.姓名)(mytable.姓名)
if @dis = '廣東'
insert into mytable1(mytable1.姓名,mytable1.縣市區)(mytable.姓名,mytable.縣市區) --这里是你的Insert语句
fetch cuTemp into @name, @dis
end
close cuTemp
DEALLOCATE cuTemp