DECLARE @sqlQuery NVARCHAR(MAX)
DECLARE @outputFilePath NVARCHAR(MAX)

SET @sqlQuery = 'SELECT * FROM [AdventureWorks2016].[dbo].[AWBuildVersion]'
SET @outputFilePath = N'E:\programming\File.csv'

DECLARE @bcpCommand VARCHAR(2000)

SET @bcpCommand = N'bcp "' + @sqlQuery + N'" queryout "' + @outputFilePath + N'" -t, -c -T -S ' + @@Servername + N';' 

Declare @bcpCommand1 Varchar(2000) = @bcpCommand

Print @bcpCommand1

--DECLARE @outputTable TABLE (outputText NVARCHAR(MAX));
--INSERT INTO @outputTable (outputText)
--EXEC xp_cmdshell @bcpCommand;
--SELECT * FROM @outputTable;


EXEC xp_cmdshell @bcpCommand1;

-- Exec master..xp_cmdshell 'type "c:\tempexportfile.txt" >> "c:\mainexportfile.txt"

Select @@SERVERNAME