循环插入数据存储过程

declare @start int;
declare @ends int;
set @start=1;
set @ends=49;
while @start<=@ends
begin
set @start=@start+1
insert into tb_News(newstitle) values(@start);
end

转载于:https://www.cnblogs.com/thinkingthigh/archive/2013/05/08/3067192.html