How to save SQL Server data as Insert INTO SQL Script
来源:互联网 发布:linux操作系统u盘安装 编辑:程序博客网 时间:2024/05/17 02:37
/*Author : Jiangong SUN*/
If you have wondered to clean a table data, and want to save the original data in a backup sql script.
Here is a solution for it.
Right click your database -> click "Tasks" -> then click "Generate Scripts"
Then you will see an interface : "Generate scripts for database objects",
->click "Next", then "Select specific database objects",
-> then "Tables" with specific tables.
-> "Specify how script should be saved or published", and click "Advanced" , In the options, choose "Types of data to script" and modify it to "Data only".
-> click "Next" and then finish.
And then your "INSERT INTO" scripts are generated.
I hope this post can do help to your work!
0 0
- How to save SQL Server data as Insert INTO SQL Script
- SQL Server Insert data into table
- SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE
- SQL SERVER Insert into Select
- How to import a SQL Server .bak file into MySQL?
- sql server insert into 表数据转移
- How to recover deleted data from SQL Server 暴强
- How To Export MySQL Data as Insert Statements
- How to Enable Trace or Debug for APIs executed as SQL Script Outside of the Applications ?
- 1、SQL Server:SELECT INTO 和 INSERT INTO SELECT
- how to execute sql script in c#
- How do I load text or csv file data into SQL Server?
- How To Load CLOB Data from a File into a CLOB column using PL/SQL
- How to read and save Images in a Sql Server Database using ADO.NET and C#
- SQL INSERT INTO 语句
- SQL INSERT INTO 语句
- SQL INSERT INTO 语句
- SQL INSERT INTO 语句
- XMPP 实现IM(三)
- 标记一下
- 提取中文词组
- 动态监听键盘高度,并进行view的移动(防止遮住textField)
- java、MySQL时间类型的转换及存储(Timestamp、Date、String、Long)
- How to save SQL Server data as Insert INTO SQL Script
- CListCtrl
- win7 64下C/C++连接mysql
- VirtualBox 配置internal network实现虚拟机互联
- JSP中<base href="<%=basePath%>">作用
- 关于U盘引导安装Ubuntu12.4 提示/cdrom被占用的解决方案
- 用QT 还是MFC ?
- 字符串碎写
- 选择排序