Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
First SP
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Miscellaneous
Thread ID:
00759576
Message ID:
00759594
Views:
20
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform