TABLE 3: Sample Test Script for Usp_lookupPrice
Test Case 3: procedure = Usp_lookupPrice; @product_id = 4
      OUTCOMES  
Step Instruction Attribute Expected Actual Pass
3.1 Start Query Analyzer Query Analyzer Loaded Loaded  
3.2 Connect to the database server Server connection Successful Successful  
3.3 Connect to the Orders database Database connection Successful Successful  
3.4 Check for valid data values in
Products table (e.g., execute
SELECT * FROM Products)
product_id
product_price
1, 2, 3, 4, 5
19.95, 29.95,
39.95, 11.00, null
 
19.95, 29.95,
39.95, 11.00, null
 
3.5 Prepare and load the test driver with input values for test case; for example:

DECLARE @price money,
@return_value int
EXEC @return_value=sp_lookupPrice 4,
@price OUTPUT
SELECT @price "Unit Price"
SELECT @return_value "Return Value"
       
3.6 Execute the test Unit price
Return value
11.00 11.00 X