Database

INSERT INTO EmployeeMaster (FirstName, LastName, EmpID)
SELECT EmpFirstName, EmpLastName, EmpID
FROM EmployeeTemp
WHERE (...........)

UPDATE EmployeeMaster
SET EmployeeMaster.FirstName = EmployeeTemp.EmpFirstName,
    EmployeeMaster.LastName = EmployeeTemp.EmpLastName,
    EmployeeMaster.EmpID = EmployeeTemp.EmpID
FROM EmployeeTemp T INNER JOIN EmployeeMaster M ON T.EmpID = M.EmpID
WHERE (...........)

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