Hi I am using below statement to run in management studio
EXEC master..xp_cmdshell 'bcp "select * from AdventureWorks.HumanResources.Employee for xml auto,elements" queryout "C:\bcptest.xml" -T -c -SKRISHNAK'
output file that i received from this is having xml error
i want xml to be separated by each column of select statement
Is there any way to achieve this.
View Complete Post