Following are the results from the following SQL Query:

sp_helptext SelectInventoryLab4
go
sp_helptext UpdateInventoryLab4
go
sp_helptext InsertInventoryLab4
go
sp_helptext DeleteInventoryLab4
go

----------------------------------------------------------
Text
-----------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------
-----------------------------------------
CREATE PROCEDURE dbo.SelectInventoryLab4

AS
                                                                                                                                                                                                                                                            
  SET NOCOUNT ON;
                                                                                                                                                                                                                                              
SELECT ID, ProductName, WholesalePrice, RetailPrice, Description FROM tblInventory
No more results.
(4 row(s) returned)
Text
-----------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------
-----------------------------------------
CREATE PROCEDURE dbo.UpdateInventoryLab4

(
                                                                                                                                                                                                                                                             
  @ProductName varchar(75),
                                                                                                                                                                                                                                    
  @WholesalePrice money,
                                                                                                                                                                                                                                       
  @RetailPrice money,
                                                                                                                                                                                                                                          
  @Description ntext,
                                                                                                                                                                                                                                          
  @Original_ID int,
                                                                                                                                                                                                                                            
  @Original_ProductName varchar(75),
                                                                                                                                                                                                                           
  @Original_RetailPrice money,
                                                                                                                                                                                                                                 
  @Original_WholesalePrice money,
                                                                                                                                                                                                                              
  @ID int
                                                                                                                                                                                                                                                      
)
                                                                                                                                                                                                                                                             
AS
                                                                                                                                                                                                                                                            
  SET NOCOUNT OFF;
                                                                                                                                                                                                                                             
UPDATE tblInventory SET ProductName = @ProductName, WholesalePrice = @WholesalePrice, RetailPrice =
@RetailPrice, Description = @Description WHERE (ID = @Original_ID) AND (ProductName =
@Original_ProductName) AND (RetailPrice = @Original_RetailPrice OR @Original_RetailPrice IS NULL AND
RetailPrice IS NULL) AND (WholesalePrice = @Original_WholesalePrice OR @Original_WholesalePrice IS NULL AND
WholesalePrice IS NULL);

  SELECT ID, ProductName, WholesalePrice, RetailPrice, Description FROM tblInventory WHERE (ID = @ID)
No more results.
(17 row(s) returned)
Text
-----------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------
-----------------------------------------
CREATE PROCEDURE dbo.InsertInventoryLab4

(
                                                                                                                                                                                                                                                             
  @ProductName varchar(75),
                                                                                                                                                                                                                                    
  @WholesalePrice money,
                                                                                                                                                                                                                                       
  @RetailPrice money,
                                                                                                                                                                                                                                          
  @Description ntext
                                                                                                                                                                                                                                           
)
                                                                                                                                                                                                                                                             
AS
                                                                                                                                                                                                                                                            
  SET NOCOUNT OFF;
                                                                                                                                                                                                                                             
INSERT INTO tblInventory(ProductName, WholesalePrice, RetailPrice, Description) VALUES (@ProductName,
@WholesalePrice, @RetailPrice, @Description);

  SELECT ID, ProductName, WholesalePrice, RetailPrice, Description FROM tblInventory WHERE (ID =
  @@IDENTITY)
No more results.
(11 row(s) returned)
Text
-----------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------
-----------------------------------------
CREATE PROCEDURE dbo.DeleteInventoryLab4

(
                                                                                                                                                                                                                                                             
  @Original_ID int,
                                                                                                                                                                                                                                            
  @Original_ProductName varchar(75),
                                                                                                                                                                                                                           
  @Original_RetailPrice money,
                                                                                                                                                                                                                                 
  @Original_WholesalePrice money
                                                                                                                                                                                                                               
)
                                                                                                                                                                                                                                                             
AS
                                                                                                                                                                                                                                                            
  SET NOCOUNT OFF;
                                                                                                                                                                                                                                             
DELETE FROM tblInventory WHERE (ID = @Original_ID) AND (ProductName = @Original_ProductName) AND
(RetailPrice = @Original_RetailPrice OR @Original_RetailPrice IS NULL AND RetailPrice IS NULL) AND
(WholesalePrice = @Original_WholesalePrice OR @Original_WholesalePrice IS NULL AND WholesalePrice IS NULL)
No more results.
(11 row(s) returned)