Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
First SP
Message
De
01/03/2003 12:18:34
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
Divers
Thread ID:
00759576
Message ID:
00759945
Vues:
22
This message has been marked as a message which has helped to the initial question of the thread.
First guess is that either @tnCartID or @RetStat are NULL. Take a look at SET CONCAT_NULL_YIELDS_NULL in the BOL.

-Mike

>That kills me!!!
>
>print 'Cart ID =' + RTRIM(CONVERT(varchar(30), @tnCartID)) + ' Error code = ' + RTRIM(CONVERT(varchar(30), @RetStat))
>
>Doesn't print anything. If I have Error code on the second line (two print statements), it prints it, but not CartID
>
>Also how can I get rid of 1 row affected message. It starts to get on my nerves...
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform