Listing 3: Stored Procedures That the tabTestValues Table References
CREATE PROCEDURE sproc_1
 @first_name varchar(24) = 'dan',
 @last_name varchar(24) = 'johnson',
 @age int = 40
AS
 PRINT 'Input value 1: ' + @first_name
 PRINT 'Input value 2: ' + @last_name
 PRINT @age
 RETURN 0
GO
CREATE PROCEDURE sproc_2
 @product varchar(24) = 'mens winter coat',
 @quantity int = 1,
 @unit_price money = 22.54,
 @total money output
AS
 SELECT @total = @quantity * @unit_price
 RETURN 0
GO
CREATE PROCEDURE sproc_3
 @last_name varchar(15) = 'lastname',
 @error_message varchar(30) output
AS
 SELECT @error_message = 'Logic Error: 100'
 RETURN 0
GO
CREATE PROCEDURE up_lookupPrice
  @product_id int,
  @product_price money OUTPUT
AS
 IF object_id('dbo.products') IS NULL
    RETURN 10                                       /* Data table does not exist. */
 SELECT @product_price = product_price
   FROM Products WHERE product_id = @product_id
 IF @@rowcount = 0                         /* row not found */
    RETURN 11
 IF @product_price IS NULL                /* unit_price is null */
    RETURN 12
 RETURN
GO