Fork me on GitHub

循环插入数据存储过程

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

posted @ 2013-05-08 17:05  思考的大腿  阅读(195)  评论(0编辑  收藏  举报