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.
  2. FrankKalis Moderator

  3. Madhivanan Moderator

    Have you heard about Table Valued Parameters(TVP)?
  4. satya Moderator

    ...moreover I would like know whether you need it in SQL 2008 or earlier versions?
  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
  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 :).

Share This Page