网络营销电子商务研究中心  
USA Web Hosting Direct
Go Back   网络营销电子商务研究中心 > 服务器与数据库 > SQL Server
User Name
Password
 
FAQ Members List Calendar 域名注册 PHP Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1   IP: 49.87.221.211
Old 2015-12-14, 09:45 PM
New Paltz New Paltz is offline
初级会员
 
Join Date: 2008-03-22
Posts: 1
New Paltz 现在声名狼藉
Default sql 保存查询结果

可用如下方法保存数据。

1、以sqlserver2008R2为例,登录SQL Server Management。

2、新建查询窗口,写出要保存结果的sql语句,如:
select * from test;

3、出现查询结果后,在结果处点击右键,选择“将结果另存为”。




4、选择保存路径,填写文件名字,并选择保存格式后,点击“保存”按钮即可。
Attached Images
File Type: jpg 1.jpg (17.9 KB, 4 views)
File Type: jpg 2.jpg (60.9 KB, 4 views)
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sql优化34条(转) car 建站交流 0 2009-12-13 10:16 AM
X-Cart Multiple Input Validation Holes Permit SQL Injection and Cross-Site Scripting topvip X-Cart 0 2009-07-21 11:03 AM
SQL Server导出导入数据方法 topvip 服务器环境搭建 0 2009-05-06 12:04 PM
跟我学sql:(一)数据查询 topvip 建站交流 0 2009-02-12 07:41 AM
sql 经典语句 topvip 建站交流 0 2009-02-12 07:39 AM

Prescription-glasses.com offers prescription glasses online at discount prices.
所有时间均为 +8. 现在的时间是 01:35 AM, Free Patent & Patent Ideas