存取过程,使用游标遍历表中数据,修改字段后,逐条插入表中,实现测试数据构造
-- 创建存取过程
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,