Results to File using | (Vertical bar) by default as a column separator
-
Good night
in a sqlserver server cluster we're asked ro run a query and results shoulbe in a file using vertical bar (|) as colums separator.
In Sqlserver Analizar in Menu Query - Results to file i redirect the results to a file but ..
The problem is for example if a run in I.E. SERVR1 in a spcified path file, by default the columns separator is a space ( ) but no (|), so i have to query in another server SERVER2, affecting the trafiic.
How can i Tell or define in SERVER1 the caracter (|) to be the default as colums separator?
I know by designing a simple DTS you can figure out this request but id like to know if you can define by default what is the character to be as a column separator
-
the format has nothing to do with the server you are connecting to...it's a setting for Query Analyzer.
just change your export format here:
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply