Select Code to Download

CREATE PROCEDURE dbo.SOMETHING_SAVE
 @something_id int,
...
 -- Do stuff

GO

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

order by 
  CASE @order
...
  CASE @order 
      WHEN 'user_id' THEN user_id
  END

CREATE PROCEDURE [dbo].[dynamic_example]
  @lastname varchar(50) = NULL,
...
WHERE (@lastname IS NULL OR users.lastname LIKE @lastname)
AND (@firstname IS NULL OR users.firstname LIKE @firstname)
GO

EXEC dynamic_example @firstname = 'chris%'