测试ORACLE
CREATE TABLE abd(a NVARCHAR2(555),b INTEGER,c DATE);declare
i number:=1;
begin
while i<99999 loop
i:=i+1;
insert into abd(a,b,c) VALUES('drrrrrrrrrrrrrrrrree',i,sysdate);
end LOOP;
END;
/测试Sql server
CREATE TABLE abd(a NVARCHAR(555),b INTEGER,c DATE);
DECLARE @I INT;
SET @I=1;
WHILE(@I<99999)
BEGIN
INSERT INTO ABd(a,b,c) VALUES('drdrrrrrrrrrrrrrrrrrrrrr',@I,getdate());
SET @I=@I+1;
END
GO
CREATE TABLE abd(a NVARCHAR2(555),b INTEGER,c DATE);declare
i number:=1;
begin
while i<99999 loop
i:=i+1;
insert into abd(a,b,c) VALUES('drrrrrrrrrrrrrrrrree',i,sysdate);
end LOOP;
END;
/测试Sql server
CREATE TABLE abd(a NVARCHAR(555),b INTEGER,c DATE);
DECLARE @I INT;
SET @I=1;
WHILE(@I<99999)
BEGIN
INSERT INTO ABd(a,b,c) VALUES('drdrrrrrrrrrrrrrrrrrrrrr',@I,getdate());
SET @I=@I+1;
END
GO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货