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:3/11/16 8:47 AM


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 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 - meaning 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 - meaning 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? Please add it below. Your name and tip will appear at the end of the document text.
Your name:
Your email:
Hide my email address
Verification code:
Enter the verification code you see above more submitting your tip
Tip:Please limit tips to 1000 characters

Navigation

Social Media

Powered by 10MinutesWeb.com