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