--değişken atama metin ekleme vs
---sql sorgusu
declare @f nvarchar (100), @Srk NVARCHAR(30)
set @Srk='[Ent_2019MARKET]'
set @f='demo'
set @f=@f+'demo2'+convert (varchar,getdate(),104)
set @f=replace (@f,'.','')
SET @f=@f+@Srk
select @f

--Dinamik sql ile sorguya parametre vermrk.
---proc hali
alter proc sp_sl 
@f nvarchar (1000), @Srk1 NVARCHAR(1000),@Srk2 NVARCHAR(1000)
as
begin
DECLARE @SQL AS NVARCHAR(MAX)
set @Srk1=@Srk1+'.dbo.'+'ACARI'
set @Srk2=@Srk2+'.dbo.'+'ACARI'

SET @SQL='SELECT count(*) FROM '
SET @Srk1=@SQL+ @Srk1
SET @Srk2=@SQL+ @Srk2
--select output sonuc verir, exec sp_executesql ile sorgu çalıştırır.
--select @SQL , @Srk1,@Srk2
--EXEC sp_executesql @Srk1
select @Srk2,@Srk1
EXEC  sp_executesql @Srk2
EXEC  sp_executesql @Srk1
end

exec sp_sl 'f','Ent_2012','Ent_2017MARKET'