Question: how to export table data in sql server 2008 r2?
Answer: you can right click on database in the Object Explorer and select Database->Tasks->Export Data . An SQL Server Import and Export Wizard dialog opens and you will be able to export data from any table or query to the file or another destination.