How exec a sproc with parms with defaults

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mscertified - 18 Jul 2008 23:36 GMT

here are my parameters:

CREATE Procedure dbo.ESIMonthly
(
    @ProcessDate DateTime = Null,
    @SubsidyPerChild SmallMoney = 100.00,
    @Rerun bit = 0,
    @Payments int OUTPUT,
    @TotalPaid Money OUTPUT
)

since first 3 parms have defaults how do I execute this without specifying
the parameters but still grabbing the output paramaters? I tried
EXEC dbo.ESIMonthly ,,, @Payments OUT, @TotalPaid OUT
but it did not like it

Reply to this Message

Plamen Ratchev - 19 Jul 2008 00:00 GMT

You can execute explicitly naming the parameters and skipping those with
defaults:

EXEC dbo.ESIMonthly @Payments = @Payments OUT, @TotalPaid = @TotalPaid OUT;

Or use the DEFAULT keyword in place of those parameters that you do not want
to specify:

EXEC dbo.ESIMonthly DEFAULD, DEFAULT, DEFAULT, @Payments OUT, @TotalPaid
OUT;

HTH,

Plamen Ratchev
http://www.SQLStudio.com

Reply to this Message