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:
00759594
Vues:
17
>First, there's garbage at the end of your sproc. Second, double click on the error message and QA will bring you to the line with error.
Why SELECT @CartID = @@SCOPE_IDENTITY gives

Server: Msg 137, Level 15, State 2, Procedure sp_InsertShoppingCartInfo, Line 60
Must declare the variable '@@SCOPE_IDENTITY'.

My variable is declared at the top with DECLARE @CartID int
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