摘要:
declare @sql varchar(500), @count int;--循环次数begin set @count=318 while @count<350 begin set @sql = 'insert into t_rooms (id,name,type)values('+cast(@count AS varchar(10))+',''1'',1)' print @sql --execute(@sql); set @count=@count+1; end;end;
阅读全文
posted @ 2012-08-22 21:52
ventry
阅读(3262)
推荐(0)
编辑