Sql Server 存取过程读取表中数据，修改后再逐条插入

存取过程，使用游标遍历表中数据，修改字段后，逐条插入表中，实现测试数据构造

-- 创建存取过程
CREATE PROCEDURE ADD_EventData
AS
BEGIN
        DECLARE @DataID INT, @EventID  VARCHAR(50), @EventLat VARCHAR(50), @EventLon VARCHAR(50), @EventClass VARCHAR(50), @EventTime datetime, @EventByte VARCHAR(50), 
								@EventArea VARCHAR(50), @EventAddr VARCHAR(50), @EventdyMode VARCHAR(50), @EventState VARCHAR(50), @EventTurningByte VARCHAR(50), @EventTurningBelong VARCHAR(50) , @EventRegion VARCHAR(50)
        
        PRINT @EventID
				Declare MyCursor Scroll Cursor 
                  For SELECT EventLat, EventLon, EventClass, EventTime, EventByte, EventArea, EventAddr, EventdyMode, EventState, EventTurningByte, EventTurningBelong, EventRegion FROM EventData
        Open MyCursor
				Fetch next From MyCursor
            Into @EventLat, @EventLon, @EventClass, @EventTime, @EventByte,