DECLARE @TypeId INT,@Price1 FLOAT,@Original FLOATDECLARE 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 @Price1INSERT INTO [SXDB].[dbo].[DomainPrice]([PriceId],[Price],[Original],[Type],[TypeId])VALUES(NEWID(),@Price1,@Original,1,@TypeId)FETCH NEXT FROM my_cursor INTO @TypeId,@Price1,@Original--读取下一条ENDCLOSE my_cursor--关闭DEALLOCATE my_cursor--释放