if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tver]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tver]
GO
--表 tver 的结构
 CREATE TABLE tver(fid int IDENTITY (1, 1) not null,fbid varchar(255) not null,fver varchar(255) null PRIMARY KEY (fid))

--表 tver 的索引
 CREATE  INDEX [fbid_index] ON [tver]([fbid]) ON [PRIMARY]
GO


declare @i int  --变义变量@i
set @i = 1 --初始化@i为1
while @i < 100 --假如@i小于100,这里改成100万即是插入100万条记录
begin
  insert into tver (fbid,fver) values(newid(),Str(CAST(FLOOR(rand()*10000000) as int)))
  set @i = @i + 1
end

select * from tver