Question: how to export large amount of data from sql to excel?
Answer: Right click on Database in SSMS., Select Tasks-> Export data., Choose Datasource as SQL and give server name with authentication., Choose Destination as Microsoft Excel and give the excel file path., Select "Write a query to specify the data to transfer".