Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Formatting string from stored procedure
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01520619
Message ID:
01520622
Vues:
32
>>Hi,
>>
>>When I write an error to return from a stored procedure (or trigger) what character can I use to break a line?
>>For example, in VFP I can have CHR(13) in the place where I want to break the line. What can I do with (for example) the following:
>>
>>
>>RAISERROR('First line of the message. Second line of the message', 16, 1)
>>
>>
>>What kind of character to add in the line above?
>>
>>TIA
>
>
RAISERROR('First line of the message.' + CHAR(13) + ' Second line of the message', 16, 1)
Thank you. I tried it but it didn't work. I think what Naomi suggested, making a variable is the way to do it.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform