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'
Sybase存储过程批量入库
于 2018-07-04 15:53:24 首次发布