|
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 & paste.
- File - Specify the file that will receive the results
- Encoding - Indicate the character encoding
- Platform - Select either Windows or Unix platform (to choose the end-of-line delimiter)
- Results - Choose the panel containing the content to be saved
- Grid Results -
- Text Results -
- Client Statistics -
- Explain Plan -
- 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
- Click Save to Clipboard to send the results to the clipboard in the specified data format.
- Click Save to File to send the results to a file in the specified data format.
|
|
