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