Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 save querey result as cvs file

Author  Topic 

jeff06
Posting Yak Master

166 Posts

Posted - 2008-08-28 : 09:49:17
I can save the query result to cvs file but it does not include the variable name. How can include the variable in to cvs file?
I use sql sever 2005 manaegment studio,
THX.
Jeff

JeriHatTrick
Starting Member

11 Posts

Posted - 2008-08-28 : 11:40:00
Right click the query editor in Mgt. Studio and click on Query Options>Results>Text and click Include column headers in the result set.
Go to Top of Page

JeriHatTrick
Starting Member

11 Posts

Posted - 2008-08-28 : 11:41:11
That is if I interpreted your question correctly. :-|
Go to Top of Page

jeff06
Posting Yak Master

166 Posts

Posted - 2008-08-28 : 11:58:52
That is what I want. Thanks, Jerihattrick!
Go to Top of Page

JeriHatTrick
Starting Member

11 Posts

Posted - 2008-08-28 : 14:01:43
You're welcome!
Go to Top of Page
   

- Advertisement -