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