CREATE PROCEDURE dbo.SOMETHING_SAVE
 @something_id int,
 @name varchar(50)
AS

/*
 Does blah blah
 -- Changed on 2006-09-07 to resolve ticket #570
*/

 -- Do stuff

GO

##</code><code>##

$sql = q{EXEC AUTH_USER @username = ?, @password = ?};
my ($user_id) = $dbh->selectrow_array($sql,{},$username,$password);

##</code><code>##

order by 
  CASE @order
    WHEN 'name' THEN lastname
    WHEN 'state' THEN state
   END,
  CASE @order
    WHEN 'name' THEN firstname
  END,
  CASE @order 
      WHEN 'user_id' THEN user_id
  END

##</code><code>##

CREATE PROCEDURE [dbo].[dynamic_example]
  @lastname varchar(50) = NULL,
  @firstname varchar(50) = NULL
AS

SELECT * from Users
WHERE (@lastname IS NULL OR users.lastname LIKE @lastname)
AND (@firstname IS NULL OR users.firstname LIKE @firstname)
GO

##</code><code>##

EXEC dynamic_example @firstname = 'chris%'