代码如下:–>Title:Generating test data –>Author:wufeng4552 –>Date :2009-10-07 15:16:26 if object_id(‘ta’)is not null drop table ta go create table ta(ID int identity,[name] varchar(10)) insert ta([name]) select ‘a’ union all select ‘b’ union all select ‘c’ union all select ‘d’ union all select ‘e’ union