my $sth1 = $db->prepare('EXEC dbo.Foo ?');
$sth1->execute(1); # use the default for the second param