这是为所有数据生成Insert语句的快速运行在您的表中，不使用SQL Management Studio 2008中的脚本或加载项：

1.右键单击数据库并转到任务 - >生成脚本

2.选择要生成脚本的表（或对象）。

3.转到设置脚本选项并单击高级按钮。

4.在常规类别中，转到脚本数据类型

5.有3个选项：仅架构，仅数据，架构和数据。选择适当的选项，然后单击OK。



然后，您将直接从SSMS获取CREATE TABLE语句和所有INSERT语句。



如果这样可以解决您的问题并将其标记为解决方案..谢谢..

This is a quick run through to generate Insert statements for all of the data in your table, using no scripts or add-ins to SQL Management Studio 2008:
1.Right click on the database and go to Tasks -> Generate Scripts
2.Select the tables (or object) that you want to generate the script against.
3.Go to Set scripting options and click on the Advanced button.
4.In the General category, go to Type of data to script
5.There are 3 options: Schema Only, Data Only, and Schema and Data. Select the appropriate option and click on OK.

You will then get the CREATE TABLE statement and all of the INSERT statements for the data straight out of SSMS.

If this solves your issue kindly up vote and mark this as solution.. Thanks..