insert update query in sql server

Devendra Kumar

10y1.1k

hi any buddy help please

i have one sp in which i will insert and update up product like this:

Create PROCEDURE [dbo].[Sp_AddToMyCart]

@SessionId varchar(500),

@Product_Fkid int,

@size_Fkid int,

@Qty int

Declare @count int,@ReturnValue int

BEGIN

Set @count=(Select COUNT(1) from dbo.MyCart where SessionId=@SessionId and Product_Fkid=@Product_Fkid)

if(@count=0)

begin

Insert into dbo.MyCart(SessionId,Product_Fkid,Qty,size_Fkid) values (@SessionId,@Product_Fkid,@Qty,@size_Fkid)

Set @ReturnValue=1

end

else

begin

update dbo.MyCart

Set Qty=@Qty

where SessionId=@SessionId and Product_Fkid=@Product_Fkid

Set @ReturnValue=2

end

return @ReturnValue

END

insert update work properly but i face a problem when

i want insert same product then it return this product already add in your cart

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dharmesh Singh10y ago
1. CreatePROCEDURE[dbo].[Sp_AddToMyCart]
2. @SessionIdvarchar(500),
3. @Product_Fkidint,
4. @size_Fkidint,
5. @Qtyint
6. AS
7. Declare@countint,@ReturnValueint
8. BEGIN
9. --Set@count=(SelectCOUNT(1)fromdbo.MyCartwhereSessionId=@SessionIdandProduct_Fkid=@Product_Fkid)
10. ifnotexists(Select*fromdbo.MyCartwhereSessionId=@SessionIdandProduct_Fkid=@Product_Fkid)
11. begin
12. Insertintodbo.MyCart(SessionId,Product_Fkid,Qty,size_Fkid)values(@SessionId,@Product_Fkid,@Qty,@size_Fkid)
13. Set@ReturnValue=1
14. end
17. else
18. begin
19. updatedbo.MyCart
20. SetQty=@Qty
21. whereSessionId=@SessionIdandProduct_Fkid=@Product_Fkid
22. Set@ReturnValue=2
23. end
24. return@ReturnValue
25. END
try if not exists key word

Pankaj Kumar Choudhary10y ago

Hello! Devandra i think your question is not a big query but there is unclear issues like

are you want to get " product already add in your cart" this message as output from stored procedure when data is already exist or you are getting this error message when you are trying to insert some values...............