spLoadRecord_ShoppingCart_ByCookieID
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ShoppingCartPartID | int | IN | |
| @CookieID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure [dbo].[spLoadRecord_ShoppingCart_ByCookieID](@ShoppingCartPartID int, @CookieID uniqueidentifier) as
exec dbo.[spPurgeExpiredShoppingCarts]
-- try to keep the columns returned consistent across these SPs:
-- spLoadRecord_ShoppingCart, spLoadRecord_ShoppingCart_ByClientUsersID, spLoadRecord_ShoppingCart_ByCookieID
select
ID,
ShoppingCartPartID,
ClientUsersID,
CreateDate,
UpdateDate,
CookieID
from dbo.ShoppingCart
where CookieID = @CookieID
and ShoppingCartPartID = @ShoppingCartPartID;
return;