Database

declare @t table(record varchar(100))
insert into @t 
	select 'Hello-World' union all
	select 'code - project codes are good' union all
	select 'hello' union all
	select ' world' union all
	select ' how are u-?'

select * from @t where record like '%[-]%'

record
Hello-World
code - project codes are good
 how are u-?

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