使用sql server（sql server management studio）中的完整数据生成脚本 [英] Generate Script with full data from sql server (sql server management studio)

问题描述

你好，



我用sql server数据库创建了一个应用程序，用于维护表，stroed程序，我已经使用sql server管理工作室了。

现在我想备份完整数据意味着我插入了超过500条记录。所以，我希望在sql脚本中支持500条记录和表脚本。哪个文件的扩展名是.sql。







谢谢和问候，

Hello,

I have create one application with sql server database, for maintain table, stroed procedure,I have using sql server management studio.
Now i want to back up full data means i have inserted around more than 500 records. so, i want to back with 500 records and table scripts all as in sql script. which file's extension is .sql.



Thanks & Regards,

推荐答案

当您生成脚本时

When you are generating script

1. In Set scripting Option window Click on  Advanced button
2. One Option window will appear
3. There is a option in General "Types of data script":
4. Choose "Schema and data"

您将获得带有表记录的表脚本插入脚本

You will get table script with table records insert script

这篇关于使用sql server（sql server management studio）中的完整数据生成脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！