USP_DELETE_SHOPPINGCART_ENTRY_FROM_CMSTRANSACTIONSTATE
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CARTID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_DELETE_SHOPPINGCART_ENTRY_FROM_CMSTRANSACTIONSTATE
(
@CARTID as Uniqueidentifier = null
)
as
begin
if(@CARTID is not null and @CARTID <> '00000000-0000-0000-0000-000000000000')
begin
delete from dbo.CMSTRANSACTIONSTATE
where DATA like '%'+ convert(nvarchar(50), @CARTID)+ '%';
end
end