Ms-sql exporting data to Excel using the xp_cmdshell command

' bcp "Select C.category_title as title, P.category_title as belongs to category from Ltblgamestore. Tbl_category as C left join Ltblgamestore. Tbl_category as P on c.category_parentid = p.category_id "queryout D:\test\Temp.xls  -c-q-S" 192.168.100.18 "-u" sa "-p "A_123"'

Database usage: Master

The table name in the SQL statement to be queried is written as: database name. Table name

To put the exported files under the folder and give this folder the Everyone permission

Ms-sql exporting data to Excel using the xp_cmdshell command