WinSQL » Knowledge base

Document information

Document ID: 4783
Subject: Copying and pasting data from a result grid in WinSQL
Creation date: 3/11/16 8:34 AM
Last modified on: 12/11/18 2:15 PM

Copying and pasting data from a result grid in WinSQL

Previous versions (older than v10) allowed users to press CTRL+A and CTRL+C to copy and paste data from a result grid to clipboard.

Version 10 offers a single key shortcut to copy entire data to your clipboard. This shortcut by default is CTRL+ALT+C and the corresponding menu item is Copy All under the main Edit menu. See image below...

The Copy All command is context-sensitive. It copies the content from currently selected control. Therefore, if to copy entire query script, ensure the mouse focus is in the query window before pressing CTRL+ALT+C. Similarly, select any cell in the grid to select entire grid.
Copy All

Extended Copy

Additionally, users can right click on a resultset within a grid and select Extended Copy to copy either one row, column or entire grid.

Copy All

Why does CTRL+A does not work

Selecting every cell in the result grid is disabled by design. The grid control in WinSQL 10 is virtual. The actual data resides in a temporary file and WinSQL brings data from this file on an as-needed basis. This allows WinSQL to store millions of rows without running out of memory.

Forcing WinSQL to select every column causes that entire resultset to load in memory, which not only takes a long time but can potentially cause out-of-memory errors.

Add a comment to this document

Do you have a helpful tip related to this document that you'd like to share with other users?

Important: This area is reserved for useful tips. Therefore, do not post any questions here. Instead, use our public forums to post questions.


Social Media

Powered by