select top 10000 id=identity(int,1,1),content = newid() into #t from sysobjects,syscolumnsselect * from #t
insert into [table](id,content) select top 10000 1,newid() from syscolumns,syscolumns
如果我想让content中的内容是中文呢
SELECT TOP 10000 id=identity(int,1,1),content = description into #t FROM master.dbo.sysmessages WHERE msglangid IN ('2052','1028') ORDER BY NEWID() GO SELECT * FROM #t
select top 10000 1,newid() from syscolumns,syscolumns
ORDER BY NEWID()
GO
SELECT * FROM #t