[TSQL] String concatenation

[ironcurtain]

While trying to run below query I got error:

Incorrect syntax near '+'.

declare @filepath varchar(50)set @filepath = 'e:\tsql\'create table #tab1 (name varchar(100))insert #tab1 exec master..xp_cmdshell 'dir /b "'+@filepath'"+"'*.txt'"'

I think there is issue with quatation marks but I couldn't find any solution. Please help.

[ironcurtain]

I founded solution for above:

declare @filepath varchar(50)set @filepath = 'e:\tsql\'declare @filetype varchar(5)set @filetype = 'txt'declare @commamd varchar(50)set @commamd = 'dir /b '+@filepath+@filetypecreate table #tab1 (name varchar(100))insert #tab1 exec master..xp_cmdshell @command