>>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?