Re: Line Break in T-SQL

From: "Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 15 Sep 2006 12:40:35 GMT

The line terminator on a Windows platform is carriage return/line feed
(ASCII 10 and 13). You can concatenate CHAR(13) + CHAR(10) where you want
line breaks.

--
Hope this helps.

Dan Guzman
SQL Server MVP

<nashak@xxxxxxxxxxx> wrote in message
news:1158285904.128023.10670@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hello,

In a Stored Proc, I am building a string variable. I am getting outputs
from 4 different queries and would like the string to have line breaks
to display each entry in a different line in a text area. How can I do
this?

i.e
result = result1 + result2 + result3 + result4.
What characters can I enter so that the output is displayed in the
textarea as
result1
result2
result3
result4

Thanks,

References:
- Line Break in T-SQL
  - From: nashak

Prev by Date: Re: Newbie Question on DB Maintenance Plan
Next by Date: Re: sql server i/o bottle neck ?
Previous by thread: Re: Line Break in T-SQL
Next by thread: Row versioning in SQL 2000?
Index(es):
- Date
- Thread

Relevant Pages

Line Break in T-SQL
... In a Stored Proc, I am building a string variable. ... from 4 different queries and would like the string to have line breaks ... to display each entry in a different line in a text area. ...
(comp.databases.ms-sqlserver)
Re: From Row to Cell
... is the value of each row....I want to put it as cell as an Expression ... ..Result1 is the expression that get the value of the test on the first row ... > David Portas ... > SQL Server MVP ...
(microsoft.public.sqlserver.programming)
Re: SQL 2005 Management Studio: Line Numbers in Query Window.
... Dan Guzman ... SQL Server MVP ... > Can anyone tell me if you can display line numbers in the query window ...
(comp.databases.ms-sqlserver)