DECLARE @i SMALLINT
SET @i = 1
WHILE (@i <=400000)
BEGIN
INSERT INTO inspect_item(inspect_step_id,inspect_type_id,inspect_type_name,inspect_order,light_type,logdate,unitsales)
VALUES(16000+@i,33,'ckj'+'@i',1,0,getdate(),0)
SET @i = @i + 1
END
表数据的批量插入
于 2022-11-30 10:27:51 首次发布