Help for this page

Select Code to Download


  1. or download this
    CREATE PROCEDURE dbo.Foo (
      @Required Int,
      @Optional Int = 0
    ) AS ...
    
  2. or download this
    my $sth2 = $db->prepare('EXEC dbo.Foo ?, ?');
    $sth2->execute(1,2);
    
  3. or download this
    my $sth1 = $db->prepare('EXEC dbo.Foo ?');
    $sth1->execute(1); # use the default for the second param