Post reply

HOw to pass a table as input parameter to a user defined function

  • April 29, 2004 at 2:31 pm

    #59707

    Hi,

     

    I wanna pass a table as input parameter to a user defined function. Is there anyway i can do it

     

    Thanks

    Ashihs

  • April 30, 2004 at 6:46 am

    #504810

    Nonscalar types such as cursor and table cannot be used as input parameters for user defined functions. See SQL Server Books Online (Create Function) for more information.

  • April 30, 2004 at 9:34 am

    #504854

    Can you describe a fbit more of what you need to do?  it is possible for you to reference a temp table from inside the udf...but you can't pass a temp table variable into a udf.

    steve

  • May 5, 2004 at 9:32 pm

    #505394

    You might want to look into User-Defined Functions That Return a table Data Type.

    They might give you the functionality you're looking for.

     

     

Viewing 4 posts - 1 through 3 (of 3 total)

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