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.
Additionally, users can right click on a resultset within a grid and select Extended Copy
to copy either one row, column or entire grid.
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.