sql 批量插入数据

sql 批量插入数据

--select count(*) from his_alarm
--DELETE  FROM his_alarm where his_alarm.alarm_time = '2019-07-23 10:12:24.000'
DECLARE
    @i INT 
    SET @i = 0
WHILE
        ( @i < 300000 ) BEGIN
            INSERT INTO his_alarm (
                [alarm_time],
                [alarm_code],
                [subsys_id],
                [alarm_desc],
                [alarm_location],
                [alarm_objectid],
                [status],
                [alarm_acktime],
                [alarm_ackuser],
                [alarm_proctime],
                [alarm_procuser],
                [alarm_procdesc],
                [alarm_recovertime],
                [alarm_recoveruser] 
            )
        VALUES
            (
                N'2019-07-23 13:12:21.000',
                N'990000045',
                N'100000061',
                N'适配器连接异常 ',
                N'',
                N'100000061',
                N'1',
                N'2019-07-22 14:12:21.000',
                N'超时确认',
                NULL,
                NULL,
                N'[超时确认]',
                NULL,
            NULL 
            ) 
        SET @i =@i + 1 
END

 

上一篇:Setup QT 5.5.1 + OpenCV 3.0 + Visual Studio 2013 on windows 10


下一篇:ORACLE中的字符串替换 replce、regexp_replace 和 translate