Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
First SP
Message
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
Divers
Thread ID:
00759576
Message ID:
00759822
Vues:
23
>>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform