sql 批量插入测试数据

DECLARE @iStart INTDECLARE @iEnd  INTDECLARE @i INTDECLARE @iCount INTSET @iStart = 1SET @iEnd = 100000SET @i=@iStartWHILE (@i <= @iEnd) BEGIN insert into websites(websites_name,url,edition_name,user_id,remark,state,is_public) values('测试'+convert(varchar(10),@i),'http://www.hoguan.com'+convert(varchar(10),@i),'新闻'+convert(varchar(10),@i),2,'孙菲菲热温热额外热'+convert(varchar(10),@i),1,1)SET @i=@i+1END