Sybase存储过程批量入库

CREATE TABLE range(
   city_id       VARCHAR(15),
   main_vcid INTEGER,
   back_vcid INTEGER,
   status      INTEGER,
   vcid_type      INTEGER,
   update_time INTEGER,
   operator varchar(20)
)
create unique index index1 on range(city_id,main_vcid,back_vcid)
--删除存储过程
DROP PROCEDURE insert_vcid_range
go

--创存储过程
CREATE PROCEDURE insert_vcid_range
        @begin INTEGER,@end INTEGER,@cityId varchar(15)
AS
 
DECLARE 
        @i INTEGER          --循环变量
        ,@startTime datetime
        ,@print varchar(30)  --打印参数
BEGIN
 
SELECT @i = @begin
SET @startTime = getdate() --设置开始时间
select getdate()
 
 WHILE @i<@end
BEGIN 
 
IF @i%400 = 0  --每400条打印一次耗时日志
begin
SELECT @print = convert(varchar(30),datediff(ss,@startTime,getdate()))
set @print = '值: '+convert(varchar(30),@i)+', 耗时(秒): '+@print
print @print
end
 
INSERT INTO range
(
   city_id,
   main_vcid,
   back_vcid,
   status,
   vcid_type,
   operator
)
VALUES
(
    @cityId,
    @i,
    @i+1000000,
    0,
    0,
    'test'
)
 
SELECT @i = @i + 1
END
 
SELECT city_id,count(*) as numbers FROM range group by city_id
END
 GO 
--存储过程结束
 
--执行存储过程

 --插入数据量，可修改
EXEC insert_vcid_range 100000000,100010000,'0310'