Database

select REPLICATE ('abcd', 1000)

PRINT 'abcd'
   GO 10000

with cte as
( select 1 as rn,'abcd' as data
union all
select rn+1, 'abcd' as data from cte where rn<1000)

select data from cte option (maxrecursion 0)

DECLARE @x XML
SELECT @x =   REPLICATE ('<x>abcd</x>', 1000)
SELECT i.value('.', 'VARCHAR(MAX)') ReplacedStrings
		FROM @x.nodes('//x') x(i)

recursive cte

declare @t table(name varchar(50))
;with cte as
( select 1 as rn,'abcd' as data
union all
select rn+1, 'abcd' as data from cte where rn<1000)

insert into @t
select data from cte option (maxrecursion 0)

select * from @t

declare @t table(name varchar(50))
DECLARE @x XML
SELECT @x =   REPLICATE ('<x>abcd</x>', 1000)
insert into @t
SELECT i.value('.', 'VARCHAR(MAX)') ReplacedStrings
		FROM @x.nodes('//x') x(i)
		
select * from @t

create table #tblname ( 
col1 varchar(200)
)

declare @i as int
set @i=0
while @i<=1000
begin
set @i=@i+1
insert into #tblname  values ('abc')
end

select * from #tblname

drop table #tblname

select top 1000 'a' 
from dbo.sysobjects as so1, dbo.sysobjects as so2

arun_pk wrote:

but u are failed to answer my q

select top 1000 'a' from dbo.sysobjects as so1, dbo.sysobjects as so2

arun_pk wrote:

u buy SQL basics

arun_pk wrote:

but u are failed to answer my q

arun_pk wrote:

u buy SQL basics

Mycroft Holmes wrote:

what if sysobjects less than 100 records, add another cross join

Ashfield wrote:

he now has enough info to work it out for himself

Ashish Kumar Vyas wrote:

run a process in a job.

Insert into DataBaseTable 
select * from SourceTable