Professional Web Applications Themes

SQL Output to a file - Microsoft SQL / MS SQL Server

How can I send the result of SQL statement to a file using Query yzer? Thanks...

  1. #1

    Default SQL Output to a file

    How can I send the result of SQL statement to a file
    using Query yzer?

    Thanks
    Emma Guest

  2. #2

    Default Re: SQL Output to a file

    Hello Emma !

    Try this.

    --Using bcp command
    bcp "select * from northwind..customers" queryout "c:\test.txt" /c /Usa /P
    /S<servername>

    Jens Süßmeyer.


    Jens Guest

  3. #3

    Default Re: SQL Output to a file

    From the menu select: Query / Results to File... (Ctrl+Shift+F).

    Or ,if the result is a reasonable size, just cut-and-paste from the Results
    window into a file.

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --

    "Emma" <com> wrote in message
    news:08f001c3673a$63beab30$gbl... 


    David Guest

  4. #4

    Default Re: SQL Output to a file

    See
    http://www.nigelrivett.net/WriteTextFile.html

    Might be easier to just cut and paste into notepad or save
    the result from q-a.

     
    (Ctrl+Shift+F). 
    paste from the Results 
    >
    >
    >.
    >[/ref]
    Nigel Guest

Similar Threads

  1. Output File name
    By Tom_F_Carroll@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 2
    Last Post: May 5th, 10:55 PM
  2. P Text File and Output to File
    By John M. Lembo in forum PERL Miscellaneous
    Replies: 2
    Last Post: August 1st, 09:52 PM
  3. P HTML file, output to csv file
    By Geoff Berrow in forum PHP Development
    Replies: 1
    Last Post: July 8th, 12:57 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139