5.7 Saving Query Results

With Query Analyzer's Save Results feature, the user can save the results of a statement execution to a variety of different file formats or copy them to the clipboard for easy copy and paste.

1. File - Specify the file that will receive the results
2. Encoding - Indicate the character encoding
3. Platform - Select either Windows or Unix platform (to choose the end-of-line delimiter)
4. Results - Choose the panel containing the content to be saved
   • Grid Results -
   • Pivot Grid Results -
   • Text Results -
   • Client Statistics -
   • Explain Plan -
5. Data Format - Select the format of the data to be saved
   • Delimited Data - save the results as a series of delimited rows of data
     • Delimiter - character used to delimit columns of data
     • String quoted identifier - character used to delimit strings
     • Include columns as first row - Include column names as the first row of the document
     • Include row count as first column - include row number in the first column of each row
     • Set text to (null) on NULL value - use the string "(null)" to represent a NULL value in the document
   • INSERT Statements - save the results as a series of INSERT SQL statements
     • Schema Name - specify the name of the schema containing the table
     • Table Name - specify the table name
     • Statement Separator - select a statement separator
     • Include table CREATE as first statement - include a CREATE SQL statement as the first statement of the document
   • XML Document - save the results as an XML document
     • String quoted identifier - character used to delimit strings
     • Include columns as first row - include column names as the first row of the document
     • Include row count as first column - include row number in the first column of each row
     • Set text to (null) on NULL value - use the string "(null)" to represent a NULL value in the document
   • HTML Document - save the results as a formatted HTML document
     • Include SQL Statement - include the SQL statement in the document
     • String quoted identifier - character used to delimit strings
     • Include columns as first row - include column names as the first row of the document
     • Include row count as first column - include row number in the first column of each row
     • Set text to (null) on NULL value - use the string "(null)" to represent a NULL value in the document
   • Excel Worksheet - save the results as a Microsoft Excel spreadsheet
     Note: this format cannot be sent to the Clipboard
     • Include SQL Statement - include the SQL statement in the document
     • Include columns as first row - include column names as the first row of the document
     • Include row count as first column - include row number in the first column of each row
     • Set text to (null) on NULL value - use the string "(null)" to represent a NULL value in the document
6. Click on the Preview Script Tab to see what Aqua Command script you may have set to run on the results before saving.
7. Click Save to Clipboard to send the results to the clipboard in the specified data format.
8. Click Save to File to send the results to a file in the specified data format.