>>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...
If it's not broken, fix it until it is.
My Blog