用循環按一定的規則insert
如:
declare @i int
set @i=0
while @i<1000
begin
insert into table select col1='A'+cast(@i as varchar),col2='b'+cast(@i as varchar)
set @i=@i+1
end
如:
declare @i int
set @i=0
while @i<1000
begin
insert into table select col1='A'+cast(@i as varchar),col2='b'+cast(@i as varchar)
set @i=@i+1
end
我听说SQL Server 2000有这个功能,能自动根据你自己的数据类型定义生成仿真数据!!
先找兩個比較大的table,讓他們之間做CROSS JOIN,然後再用NewID()或是rand()函數隨機生成一些測試資料如:
INSERT INTO TableName(Fld1,fld2)
select LEFT(cast(newid() as varchar),3) ,
LEFT(Cast(newid() as varchar),5),
From Northwind..Orders
CROSS JOIN
Northwind..Customer
谢谢我先试试!To: warning(爱就爱了)
PowerDesigner WarehouseArchitect 在什么地方能找到?怎么使用?