insert dummy row in table

--select * from employees
create table t1
(
rid int identity(1,1) not null primary key,
rname varchar(1000),
AddedOn datetime,
AddedBy varchar(100)
)
declare @iCounter int
set @iCounter = 1
while @iCounter < 10000
begin
insert into t1 values('rajesh'+cast(@iCounter as varchar),getdate(),suser_sname())
if @iCounter = 500 break -- if you want break after particular number of interval
set @iCounter= @iCounter +1
end

select * from t1
drop table t1