Dump Table date to SQL using Microsoft SQL Server

You can export the data in a table or DB into a SQL query using Microsoft SQL server Management studio by doing:
right click on the DB -> Tasks -> Generate Scripts. On the wizard step titled "Set Scripting Options" choose "Advanced" and modify the "Types of data to script" option to "Data"

This question was answered in http://serverfault.com/questions/147638/dump-microsoft-sql-server-database-to-an-sql-script