Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Save as in Toad Expand / Collapse
Posted Sunday, June 7, 2009 8:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 1, 2012 8:16 PM
Points: 237, Visits: 764
i am trying to save the output of a query to a delimted text file with comma as delimter.

if a column contains a column with column (For example John,smith) John goes to one column and smith to other column

how do i avoid and make it as one column.

Please let me know
Post #730377
Posted Sunday, June 7, 2009 10:24 AM


Group: General Forum Members
Last Login: Today @ 8:07 AM
Points: 2,996, Visits: 2,039
I.m using SQL2008 so the exact option may differ to mine.

In SQL Management Studio from the tools/options menu look for the "query results" branch on the left hand side.
In results to text the "Output format" has a number of options which includes TAB delimited and also has the ability to specify a custom delimiter

LinkedIn Profile
Newbie on
Post #730391
Posted Tuesday, June 9, 2009 4:54 AM



Group: General Forum Members
Last Login: Friday, July 17, 2015 8:32 AM
Points: 489, Visits: 745

Are you using Toad for SQL Server? I use the Oracle version (9.7.2), so I don't know if this will be applicable.

Do you have the 'Save Grid Contents' dialog on screen, Export Format: Delimited Text?

Go to String Quoting and pick 'Double Quote String Columns'. Most import tools (including Excel and SQL*Loader) are happy with column values enclosed in double quotes.

Alternatively, you can could change the Delimiter (next option) if your import tool is happy with that . . . I alwasy use ^ - never seen it in data yet . . .

Post #731309
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse