DECLARE @ROW NUMERIC(10)
DECLARE @CARTID CHAR(36)
DECLARE @PRODUCTID INT
SET @CartID = '535768cb-2e52-4f6e-ab03-c03d73b0a6c1'
SET @PRODUCTID =33
SELECT @ROW = COUNT(*) FROM PShoppingCart
WHERE CartID = @CartID AND ProductID = @ProductID
--PRINT @ROW
IF @ROW <> 1
BEGIN
.......
ELSE
DECLARE @CARTID CHAR(36)
DECLARE @PRODUCTID INT
SET @CartID = '535768cb-2e52-4f6e-ab03-c03d73b0a6c1'
SET @PRODUCTID =33
SELECT @ROW = COUNT(*) FROM PShoppingCart
WHERE CartID = @CartID AND ProductID = @ProductID
--PRINT @ROW
IF @ROW <> 1
BEGIN
.......
ELSE