Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
First SP
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Miscellaneous
Thread ID:
00759576
Message ID:
00759822
Views:
16
>>>>Mike,
>>>>
>>>>I've done exactly the same, but now I can not compile. It gives me an error on RAISERROR ('Can not add CartContent for the User ' + @tcUserID ,16,1)
>>>>
>>>>My tcUserID was passed as char(20) parameter. I've changed it to varchar(20), but it gives the same error. How can I do string concatenation in SQL Server? What could be wrong here?
>>>
>>>It's no the way RAISERROR works.
RAISERROR ('Can not add CartContent for the User %s',16,1, @tcUserID)
See BOL for details.
>>
>>I've copied Help on RAISEERROR from my work computer to my home (using PCAnywhere) and right now I'm reading it in Notepad and trying to understand...
>>
>>I'm working through PCAnywhere, since at home I have Windows 98 and no SQL Server...
>
>I find it impossible to work with T-SQL w/o BOL. If you're planning to work with SQL server from home, get BOL on your home computer.

I don't know, how to install BOL only. Anyway, I'm going to only finish this particular procedure from home, then invoke it from ASP page. Hope to finish with it on weekend...
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform