Skip to content

Instantly share code, notes, and snippets.

@csdear
Created November 3, 2014 19:56
Show Gist options
  • Save csdear/e44a968fc7821d6b3468 to your computer and use it in GitHub Desktop.
Save csdear/e44a968fc7821d6b3468 to your computer and use it in GitHub Desktop.
Preserve leading zeroes when copy and pasting SQL to Excel
--wrap the column name with this...
SELECT '="' + dealer_code + '"', dealer_name
FROM dealers
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment