is that date vill be In mm/dd/yyyu format

i excuted the query as follow with Database and schema with quey

EXEC xp_cmdshell 'bcp "SELECT * FROM [DB_SCG] [SHIVA] [TB_Category] " queryout "C:\bcptest.txt" -T -c -t,'

i got the error as...

THank you for your reply..

But i want to store or export xml file to local machine PLease answer me