Home All Groups Group Topic Archive Search About

Text Qualifier in a CSV file from results in SQL Server 2k5 Man. S

Author
25 Oct 2006 4:29 PM
Greg Toronto
When I save my results of a query in SQL Server 2k5 Management Studio, I can
save it as a csv file.  I have found where I can change the delimiter, but I
can't find a place to put in a text qualifier.  For example, I want the text
to appear with Double-Quotes around it.

Where can I configure this setting?  For the life of me I can't find it...

Thanks in advance,

Greg

Author
25 Oct 2006 9:52 PM
Erland Sommarskog
Greg Toronto (GregToro***@discussions.microsoft.com) writes:
> When I save my results of a query in SQL Server 2k5 Management Studio, I
> can save it as a csv file.  I have found where I can change the
> delimiter, but I can't find a place to put in a text qualifier.  For
> example, I want the text to appear with Double-Quotes around it.
>
> Where can I configure this setting?  For the life of me I can't find it...

I would guess the Export Wizard is what you should try. Or copy and
past into Excel and work from there. Notice that Mgmt Studio has a
nifty option that permits you to include the grid header when you
copy the grid.


--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

AddThis Social Bookmark Button