Copy Results Grid data to Excel (as xml Spreadsheet)
Copying data from Results grid to Excel via built-in Ctrl-C or Ctrl-Shift-C commands results in the loss of data type information:
Regular copy-paste function operates with text representation of data, so Excel needs to "guess" its type and regional settings. SSMSBoost allows you to copy Results Grid data in XML Spreadsheet format
, preserving data type and information precision.
Bold font is used for table headers. Strings remain Strings, DateTime remains DateTime and Numeric and Money data keep their precision and scale.
If you like this feature, make sure you read about Results Grid Scripting
: it is way more flexible, customizable and designed to output really bit amounts of data.