Displaying Query Results

WinSQL Professional allows you to display query results in the following formats:

Grid

Text

Form

It is recommended that you display results in Grid unless you are running a query that returns large amount of text containing new line characters. Managing result sets that are displayed in Grid is much easier than in Text. For example, you can save the contents of the results Grid to a CVS, tab-delimited, or spreadsheet file.

Note: The result is limited to 16MB characters per cell when the data displays in a Grid control, 4096 characters when displayed in the Text control and 32 KB when displayed in the Form control. Since it is not practical to display the entire 16 MB of data in one grid cell, WinSQL will display a magnifying glass icon if the cell data is greater than 1024 characters. You may lick the magnifying glass to zoom and view the entire data. In case of text field, data will get truncated if the length is greater than 4096 characters. This will not happen if you try to export the field to another database.

To select the method used to display query results, click the down arrow in the Execute Queries drop-down list, depicted as follows:

 

 

 

The resulting data display can be modified to include or exclude certain columns by clicking the X in the column header:

 

 

This functionality is also available for the Browse Data Grid option available in the Catalog Details tab.

Note: Right-click and select Display all columns to display formerly hidden columns.