Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Concat string
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01084298
Message ID:
01084305
Views:
13
Thanks Sergey.

>
RAISERROR('Error %d', 16, 1, @@ERROR)
>
>>I am trying to concat a string within RAISERROR()
>>Something like this:
>>
>>RAISERROR('Error' + CAST(@@ERROR AS CHAR(8)), 16, 1)
>>
>>
>>But the server doesn't like the syntax around '+'
>>
>>What is the best way to do this?
>>
>>Einar
>>
>>UPDATE:
>>This works but is there another way:
>>
>>DECLARE @einar nvarchar(50)
>>SET @einar = 'Error' + cast(@@error AS char(8))
>>RAISERROR (@einar, 16, 1)
>>
Semper ubi sub ubi.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform