By default when you copy/paste data from a query window in SSMS it does not copy the column headings. How can I get these headers to be copied along with the data?
views:
9answers:
3
+1
A:
- Open Tools menu
- Open Options...
- Expand Query Results
- Expand SQL Server
- Expand Results to Grid
- Check Include column headers when copying or saving the results
Note that this will only work on the "New Query" types of windows -- not the "Open table" (editable) windows.
Joe Philllips
2010-08-27 14:35:10
A:
You can just right click the results, and select "Copy with headers"
AdaTheDev
2010-08-27 14:38:53
Which version? I don't see the option in 2005 (yes, I just added 2005 to the question)
Joe Philllips
2010-08-27 14:44:30
@Joe Phillips - SQL 2008. I couldn't remember if it was in 2005 or not as I don't have 2005 on this machine!
AdaTheDev
2010-08-27 14:47:29
Thanks. That's good to know that they put some thought into this scenario in the next version :)
Joe Philllips
2010-08-27 14:54:12
A:
Results with headers was added in SSMS 2008. Ctrl-Shift-C works as well.
TTRider
2010-09-08 21:43:09