How to backup table's data with Sql Server 2008?

Posted on: 2011-12-16

Some time it can be useful to dump all data of a table in the format of SQL insert statement.

This can be done easily with Microsoft SQL Management Studio. The first step is to right click on the database and select the option Task>Generate Script. This will popup a wizard window.

The last step is to select that we desire only the data.

This will produce all SQL's insert statement with your data.