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