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 Pro
GO