Outputting a file from SQL on different lines instead of a single line

[july07]

Im trying to get an output file from a sql database on a .txt file, but all the out puts are on one line, how do i get them on different lines. Below is my code:

SELECT name, access, description, number syntax FROM testingresults 
WHERE LIKE 'testing%' AND access='read-write'"

This what im getting:
{testing1 read-write {This testing went well.} {} Integer32} {testing2 read-write {This testing went well.} {} Integer32}{testing3 read-write {This testing went well.} {} Integer32}{testing4 read-write {This testing went well.} {} Integer32}

I want this output instead:
{testing1 read-write {This testing went well.} {} Integer32}
{testing2 read-write {This testing went well.} {} Integer32}
{testing3 read-write {This testing went well.} {} Integer32}
{testing4 read-write {This testing went well.} {} Integer32}

Any help will be appreciated, Thanks!

 

[bborissov]

Why not use XML?

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[july07]

How do i do that?

Thanks!

 

[markros]

SELECT name, access, description, number syntax FROM testingresults
WHERE LIKE 'testing%' AND access='read-write'" FOR XML AUTO

 

[july07]

At Markros,

Im not familiar with XML.

So please can you explain your post better.

By the way, im using Tcl programming to get the output.

Thanks!

 

[markros]

Check this link

http://msdn.microsoft.com/en-us/library/ms345137(SQL.90).aspx

 

[july07]

Thank you Markros. i have gone through the link but im still kind of confused on how to implement it.

Do i have to download a program to do this, or could i do this using tcl programming.

Thanks!

 

[bborissov]

No, That is pure T-SQL code, no need to download or install anything.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[drlex]

Since the output is for a text file, would it be possible to use CHAR(13) in the results set?

declare @results nvarchar(max) 
set @results = '' 
select  @results =  @results +  name + ',' + access + ',' + description + ',' + number syntax + CHAR(13) FROM testingresults
WHERE LIKE 'testing%' AND access='read-write'
Print @results

(assuming all fields to be CHAR)

soi la, soi carré

 

[markros]

Yes, you can do this as well assuming only small number of records.