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".