Post reply

exec a proc with unknown parameters

  • June 21, 2008 at 5:21 am

    #193082

    Dear all,

    I wana know....

    Hw can we execute a procedure having numbers of parameters(like 100 ) & we know only the values of some parameters(liike only 5 from 100). Additionally we haven't passed the default values or null in the parameters definition?

    Plz suggest with a suitable example......

    Thanx

    Anurag Jain

  • June 21, 2008 at 10:06 am

    #832237

    Wither you have to pass all values, or unpassed values need defaults in the stored procedure definition.

    You can specify specific parameters as

    exec mystoredproc @param2 = 4, @param4 = 65

    But if there are not defaults, you need to pass all the parameters. You can use SSMS to view the definition of the stored procedure to get all the names and types.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply