Friday, November 12, 2010

Copying Column Names From The SQL Server Query Result

Many times you need to see the Sql Server query result into excel or you need to paste the query output in a document . default setting will copy only the data rows not the header row. To copy the headings also you can set the following options .
Query > Query Options... >Results > Grid
check option "Include the column header when Copying or saving the results" .
Click OK and you are done.



No comments:

Post a Comment