HomeDatabaseSQL Server 2005: Include Column Headers When Copying Grid Query Results

SQL Server 2005: Include Column Headers When Copying Grid Query Results

Previous versions of SQL Server have featured the ability to create grid result sets from queries so that one can easily copy and paste the data into another application. Unfortunately, the column headers were not copied, so you then would have to go into the application and add the header by hand. SQL Server 2005 provides a new option that will allow you to copy the column headers with the data. Here is how to activate this handy option…


1. Open SQL Server 2005 Management Studio.

2. Click Query and select Query Options.

3. In the Query Options dialog box, expand the Results setting in the left pane.

4. Click Grid.

5. Check the Include column headers when copying or saving the results checkbox.

6. Click OK.

Now when you copy your query results, the column headers will be copied along with the data.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

10 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android