随笔分类 -  sql

摘要:declare @i as int declare @begintime as datetime set @begintime = getdate() set @i = 0 while @i < 100 begin insert into TestT (title,info,flag) values ('title'+cast(@i as varchar),'info'+cast(ceiling(rand() * 100) as varchar ),ceiling(rand() * 2)) set @i = @i + 1 end select datedi 阅读全文
posted @ 2012-08-21 14:59 hanwest 阅读(211) 评论(0) 推荐(0)