日期:2014-05-17 浏览次数:20458 次
;with t1 as ( select number from master..spt_values where type='p' and len(number) =3 ),t2 as(select top 9 * from t1 order by newid() ),t3 as(select top 9 a.number as c1,b.number as c2 from t2 a,t2 b order by newid() ),t4 as(select top 9 * from t2,t3 where 1=1 order by newid()) select ltrim(number)+ltrim(c1)+ltrim(c2) from t4 /* 757870455 520172365 310172365 205870172 975179587 917870172 483870455 176934334 316179194 */