TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Devendra Kumar
NA
517
245.3k
insert, update store procedure in sqlserver
Apr 11 2016 7:15 AM
i'am facing a problem to update stored procedure :
both are working right insert and update procedure but facing a problem when first time insert product but when update my quantity then it update but i want when any item add in cart then it no add that product :
@SessionId varchar(500),
@Product_Fkid int,
@size_Fkid int,
@Qty int
AS
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
set @count =(select COUNT(1) from dbo.MyCart where Product_Fkid=@Product_Fkid and SessionId=@SessionId and Qty!=0 )
if(@count =1)
begin
set @ReturnValue =3
end
else
begin
update dbo.MyCart
Set Qty=@Qty
where SessionId=@SessionId and Product_Fkid=@Product_Fkid
Set @ReturnValue=2
end
return @ReturnValue
Reply
Answers (
6
)
select dropdwon list value change my url ???
How to use float in SQL for amount