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:
00759846
Vues:
18
>>>>Thanks a lot. Here is the text, it doesn't print anything. Why?
>>>
>>>You can use QA debuger to trace sproc execution.
>>>BTW, why do you keep including commented out code with each post?
>>
>>Because I thought, it could be useful for the future and didn't remove it from SP. Should I?
>>
>>Thanks for the tip, I'm going to try debug now...
>
>I meant to remove it when you post it on UT.

Didn't think about it :( I was doing copy and paste...

Anyway, how can I debug? What does it mean "parse"?

I did it line by line , but nothing happened on Print

print 'Cart ID =' + RTRIM(CONVERT(varchar(30), @tnCartID)) + ' Error code = ' + RTRIM(CONVERT(varchar(30), @RetStat)) SQL:StmtCompleted 0 0 0 0

BTW, is this duration EXECUTE @RetStat = USP_Insert_ShoppingCartInfo '241111111111' , 5 , 'Some descr' , 'B' , 'some crit' , '1,2,3' , @tnCartID OUTPUT
SQL:StmtCompleted 120 110 109 0 bad?
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