how to export table data from sql server?
['Right-click on the database that contains tables you wish to export. ... ', 'Click Next > on the Introduction page. ... ', 'On the Choose Objects page, select all of the tables you wish to export. ... ', 'On the Set Scripting Options page, select Save scripts to a specific location.']