DECLARE @TypeId INT, @Price1 FLOAT, @Original FLOAT DECLARE my_cursor CURSOR SCROLL FOR SELECT TypeId,Price1,Original FROM [DomainType]--定义游标 OPEN my_cursor--打开游标 FETCH NEXT FROM my_cursor INTO @TypeId,@Price1,@Original--读取一条 WHILE @@FETCH_STATUS=0--判断状态ahjesus循环 BEGIN--执行某些操作 --PRINT @Price1 INSERT INTO [SXDB].[dbo].[DomainPrice] ([PriceId] ,[Price] ,[Original] ,[Type] ,[TypeId]) VALUES (NEWID() ,@Price1 ,@Original ,1 ,@TypeId) FETCH NEXT FROM my_cursor INTO @TypeId,@Price1,@Original--读取下一条 END CLOSE my_cursor--关闭 DEALLOCATE my_cursor--释放