------------查询 sp_who 中的结果值。因为存储过程不能查询,先转为临时表再查询。
declare @TB table
(
spid varchar(100),
ecid varchar(100),
status varchar(100),
loginame varchar(100),
hostname varchar(100),
blk varchar(100),
dbname varchar(100),
cmd varchar(100),
request_id varchar(100)
)
insert into @TB exec sp_who
select * from @TB
select * into #t1 from @TB
-----------生成一百万条测试数据。
create table tbOrder
(
OrderNo int,
Amount int
)
create table tbOrderDetail
(
OrderNo int,
Name nvarchar(100)
)
SET NOCOUNT ON;
declare @i int
set @i=208266
declare @amount varchar(10);
while @i<1000000
begin
set @amount=cast(RAND(@i) AS varchar(10));
set @amount=SUBSTRING(@amount,6,3);
insert into tbOrder values(@i,@amount)
insert into tbOrderDetail values(@i,'Lily');
insert into tbOrderDetail values(@i,'Tim');
set @i=@i+1;
end
SET NOCOUNT Off;