在Sql Server 中如何将数据库的一个表的结构和数据全部导出为sql脚本文件?

Article View: cn.bbs.comp.database

Article #1630

Back to cn.bbs.comp.database Previous Next

#1630

From: 老鱼翁
Date: Fri, 21 Apr 2006 00:48

1 lines
1290 bytes

使用DTS好象只能导出结构.

Technical Details

Message-ID: <1145580497.283698.92050@u72g2000cwu.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!u72g2000cwu.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 101948,a66f7c15be0fd45d,start
X-Google-Attributes: gid101948,public
X-Google-Language: Chinese,UTF8
Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!u72g2000cwu.googlegroups.com!not-for-mail
From: "老鱼翁" <sunshift@gmail.com>
Newsgroups: cn.bbs.comp.database
Subject: 在Sql Server 中如何将数据库的一个表的结构和数据全部导出为sql脚本文件?
Date: 20 Apr 2006 17:48:17 -0700
Organization: http://groups.google.com
Lines: 2
Message-ID: <1145580497.283698.92050@u72g2000cwu.googlegroups.com>
NNTP-Posting-Host: 222.189.76.193
Mime-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64
X-Trace: posting.google.com 1145580502 16611 127.0.0.1 (21 Apr 2006 00:48:22 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 21 Apr 2006 00:48:22 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: u72g2000cwu.googlegroups.com; posting-host=222.189.76.193;
   posting-account=sxJRhA0AAADuo1UBLRSZY5QT3M7uE0em