Results 1 to 1 of 1

Thread: sql 保存查询结果

  1. #1
    Join Date
    2008-03-22
    Posts
    1

    Default sql 保存查询结果

    可用如下方法保存数据。

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

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

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




    4、选择保存路径,填写文件名字,并选择保存格式后,点击“保存”按钮即可。
    Attached Thumbnails Attached Thumbnails 1.jpg   2.jpg  

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sql优化34条(转)
    By car in forum 建站交流
    Replies: 0
    Last Post: 2009-12-13, 10:16 AM
  2. Replies: 0
    Last Post: 2009-07-21, 11:03 AM
  3. SQL Server导出导入数据方法
    By topvip in forum 服务器环境搭建
    Replies: 0
    Last Post: 2009-05-06, 12:04 PM
  4. 跟我学sql:(一)数据查询
    By topvip in forum 建站交流
    Replies: 0
    Last Post: 2009-02-12, 07:41 AM
  5. sql 经典语句
    By topvip in forum 建站交流
    Replies: 0
    Last Post: 2009-02-12, 07:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •