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:
00759636
Views:
22
>>Could you please help me to understand this one (and hopefully that would be it):
>>
>> UPDATE cart
>> SET LastModTs = CURRENT_TIMESTAMP,
>> @tcCartID = CartID
>> FROM cart
>> WHERE UserID = @tcUserID
>>
>>Can I get CartID while doing update? I decided, that it would be my output parameter, since I would need to get CartID anyway...
>>
>I never used UPDATE this way but according to BOL you should get CartID value.

Sergey,

Check, please, Title: Re: SP with multiple tables and databases (insert & delete) Thread #758108 Message #758227

Which method is preferable? Should I change the first part this way?
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