[ACCEPTED]-How do I add a Line break in a SQL Server Stored Procedure?-stored-procedures

Accepted answer

Score: 22

DECLARE @LINEBREAK AS varchar(2)
SET @LINEBREAK = CHAR(13) + CHAR(10)

0

Score: 1

Try this:

set @output = @output + 'aaa' + char(13)

0

Source: stackoverflow.com

More Related questions

IF/ELSE Stored Procedure

Select Average of Top 25% of Values in SQL

How do I pass input parameters to sp_executesql?

Inserting rows into a table with one IDENTITY column only

use optional parameter in WHERE clause

Stored Procedure OUT parameter always returning NULL

SQL Server : selecting multiple columns into multiple variables in a stored procedure

MS SQL Server: Check to see if a user can execute a stored procedure

t-sql stored procedure create scripts

Sorting empty values last instead of first

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.