LISTING 1: Using IF...ELSE to Execute One of a Few Pre-Programmed Queries

CREATE PROC GetSortedShippers
  @OrdSeq AS int
AS

IF @OrdSeq = 1
  SELECT * FROM Shippers ORDER BY ShipperID
ELSE IF @OrdSeq = 2
  SELECT * FROM Shippers ORDER BY CompanyName
ELSE IF @OrdSeq = 3
  SELECT * FROM Shippers ORDER BY Phone