How does SQL server write stored procedures to export data to excel?

Exec master .. xp_mongoshell 'bcp "select dd FROM ggg .. Table1" queryout "C: \ authors.xls"-C-Q-U "sa"-P "111111 "'

 

 

Using the stored procedure to export data to excel has the disadvantage that field names cannot be exported.

Excel can be generated as follows:
Set @ cmd = 'bcp' + database + '. DBO. '+ data table name + 'out' + export path + export file name +'-C-s data server name-u user name-P password'
Exec @ flag = Master .. xp_mongoshell @ cmd

-- =====Then an Excel file can be generated (the file name suffix must be *. xls) ====
Declare @ gcount int
Select @ COUNT = (select count (*) from group where sex like '%' + female + '% ')
Print @ gcount