CREATE PROCEDURE setPro --游标测试
AS --保存游标中的值 declare @Pro varchar(50) --申明游标 declare Pro CURSOR FOR select distinct province from b order by province --打开游标 OPEN Pro FETCH NEXT from Pro INTO @Pro WHILE @@FETCH_STATUS <> -1 BEGIN insert into a select province,@Pro,provinceID,'','','' from b where province = @Pro --转到下一条记录 必须 FETCH NEXT from Pro INTO @Pro END CLOSE Pro DEALLOCATE ProGO
