简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

SQL Server 2008 R2导出数据脚本的方法

WBOY
Release： 2016-06-07 17:43:48
Original
1043 people have browsed it

以前看到有些朋友说必须SQL Server 2008才能导出包含数据的脚本，后来仔细研究发现其实SQL Server 2008 R2也是可以的，只需在导出的时候在高级中设置一下即可。 1.首先在数据库上右键依次选择任务=生成脚本。 2.在弹出的窗口中选择要操作的表，然后点击下一

以前看到有些朋友说必须SQL Server 2008才能导出包含数据的脚本，美国空间，服务器空间，后来仔细研究发现其实SQL Server 2008 R2也是可以的，只需在导出的时候在高级中设置一下即可。

1.首先在数据库上右键依次选择任务=>生成脚本。

2.在弹出的窗口中选择要操作的表，然后点击下一步。

3.点击窗口上的高级按钮。

4.把滚动条拉到最下面会看到“要编写脚本的数据的类型”，在下拉中选择架构和数据或仅数据，其他选项可自行设置，然后确定即可。

，美国服务器
Related labels：
server Export data method Script
source：php.cn
Previous article：MSSQL 2005/2008 日志压缩清理 Next article： SQL逻辑查询解析
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Website using Live Server doesn't work when I launch it from a file I tried several browsers and in every case the website works fine with LiveServer. On the ...
From 2024-04-06 12:46:18
0
1
403
My React app won't load after modifying nginx proxy_pass settings I have ReactappNodeJS backend and nginx. I have obtained the certificate and installed it ...
From 2024-04-05 11:53:10
0
1
316
SQL Server: Using CASE WHEN expression with WHERE clause I have a new SpringBoot project with SQLServer and I need to replace the MySQL native quer...
From 2024-04-03 14:46:55
0
1
351
Decoding your application's database connection: Looking for help I'm new to Php and have recently been given a job with some application (php/laravel) runn...
From 2024-04-02 12:19:18
0
2
320
How do I link to a custom library when building MySQL server from source? I installed MySQL server using the standard source distribution (mysql-server-8.0) accordi...
From 2024-04-01 14:30:27
0
1
296
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！