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