SQL Server Performance

passing multiple values in a stored procedure.

Discussion in 'SQL Server 2008 General Developer Questions' started by raviatvns, Aug 8, 2011.

  1. raviatvns New Member

    Hi,

    I want to pass an arrayList for a single value in a stored procedure.
    pls suggest some methods.
    raviatvns, Aug 8, 2011
    #1

  2. FrankKalis Moderator

    FrankKalis, Aug 8, 2011
    #2

  3. Madhivanan Moderator

    Have you heard about Table Valued Parameters(TVP)?
    Madhivanan, Aug 9, 2011
    #3

  4. satya Moderator

    ...moreover I would like know whether you need it in SQL 2008 or earlier versions?
    satya, Aug 10, 2011
    #4

  5. Madhivanan Moderator

    I guess the OP is posted in 2008 and using it. If the version is prior to 2008, TVP wont be available
    Madhivanan, Aug 10, 2011
    #5

  6. satya Moderator

    Its only a guess... we can never under estimate the new members posting, without looking at forum section they might update the thread :).
    satya, Aug 11, 2011
    #6

Share This Page