Question: how to export huge data from sql server?
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".