Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image Close it
Select File

Browse by Tags · View All
sql_server 217
t-sql 211
tsql 116
sqlserver 96
BRH 78
#SQLServer 66
#TSQL 56
SQL Server 34
function 11

Archive · View All
August 2007 17
August 2010 8
June 2012 7
June 2011 7
November 2007 7
August 2012 6
May 2012 6
November 2011 6
August 2011 6
October 2011 6

Madhivanan's TSQL Blog

Exploring SSMS - Copy results with header

Aug 16 2011 3:59AM by Madhivanan   

As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to copy the results with column names included.

Suppose you want to export the query result to a text or excel file and you want to include column names in the first line, follow the following steps. After the results are shown in the grid,

Select Grid content-->Right click-->Copy with headers

Now you can paste the results to a file with first row as column names

Other posts that come under Exploring SSMS
Enabling Save Changes
Enable/disable intellisense
Connecting to msdn forums or submitting your feedback to connect
Filtering object names
Changing Top N row values

Tags: t-sql, sql_server, sqlserver, tsql, BRH, SQL Server, #SQLServer, SSMS, #BI, BI,

2 · 40% · 13039
1 Readers said this post helped them to refresh memory
Adam Tokarski said this post helped them to refresh memory on 4/2/2012 7:05:00 AM



  • in SQL 2008 R2 - Go to Tools - Options left hand side Query Results - SQL Server - Result to Grid select 2nd check box to the right - Include Column Headers when copying or saving the results

    this will always copy grid data with headers.



    commented on Aug 30 2011 9:22AM
    Anand Bohra
    604 · 0% · 60
  • @Anand: Your tip is great! Thank-you very much!

    commented on Mar 8 2012 11:51AM
    Nakul Vachhrajani
    4 · 36% · 11648

Your Comment

Sign Up or Login to post a comment.

"Exploring SSMS - Copy results with header" rated 5 out of 5 by 2 readers
Exploring SSMS - Copy results with header , 5.0 out of 5 based on 2 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]