Question: I have this code i need help explaining COU here are my tables please explain to me the @QUANITYTOSELL VARIABLE USED AS I DON'T SEE
I have this code i need help explaining COU
here are my tables please explain to me the @QUANITYTOSELL VARIABLE USED AS I DON'T SEE HOW IT IS INITIALIZED INSTEAD IT IS JUST BEING USED
SELECT FROM TBLPRODUCTTRYCATCH
SELECT FROM TBLPRODUCTSALESTRYCATCH
STORED PROCEDURE WHICH SALES PRODUCT AND IT WORKS WITH REAL TIME
ALTER PROC SPSELLPRODUCT
@PRODUCTID INT,
@QUANTITYTOSELL INT
AS
BEGINDECLARE @STOCKAVAILABLE INTFROM TBLPRODUCTTRYCATCH WHERE PRODUCTID@PRODUCTIDIF@STOCKAVAILABLE@QUANTITYTOSELL RAISERRORNOT ENOUGH STOCK AVAILABLE',IF ENOUGH STOCK AVAILABLE BEGIN FIRST REDUCE THE QUANTITY AVAILABLE WHERE PRODUCTID@PRODUCTID CALCULATE MAXPRODUCTSALESID MAXPRODUCTSALESID IS NULL FROM TBLPRODUCTSALESTRYCATCH SET @MAXPRODUCTSALESID@MAXPRODUCTSALESID IF@@ERROR ROLLBACK TRAN END BEGIN PRINT'TRAN COMMITTED' END STORED PROCEDURE WHICH SALES PRODUCT AND IT WORKS WITH REAL TIME
ALTER PROC SPSELLPRODUCT
@PRODUCTID INT,
@QUANTITYTOSELL INT
AS
BEGINDECLARE @STOCKAVAILABLE INTFROM TBLPRODUCTTRYCATCH WHERE PRODUCTID@PRODUCTIDIF@STOCKAVAILABLE@QUANTITYTOSELL RAISERRORNOT ENOUGH STOCK AVAILABLE',IF ENOUGH STOCK AVAILABLE BEGIN FIRST REDUCE THE QUANTITY AVAILABLE WHERE PRODUCTID@PRODUCTID CALCULATE MAXPRODUCTSALESID MAXPRODUCTSALESID IS NULL FROM TBLPRODUCTSALESTRYCATCH SET @MAXPRODUCTSALESID@MAXPRODUCTSALESID IF@@ERROR ROLLBACK TRAN END BEGIN PRINT'TRAN COMMITTED' END
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
