Post reply

Table data type as input parameter

  • September 25, 2003 at 6:56 am

    #81058

    Is it possible to use the table data type as an input parameter in a user defined function?

    I know this is not possible in stored procedures, but I am curious about functions because you can return a table.

    Edited by - wcalhoun on 09/25/2003 06:57:13 AM

  • September 25, 2003 at 11:00 am

    #475854

    No.

    --Jonathan



    --Jonathan

  • September 26, 2003 at 7:15 am

    #475984

    If you only need to pass "records" with one "field", you can pass a comma-delimited (or other delimited) string as a parameter and call a StringToTable function to translate the string to a table. I think I found the function I use here on this website...

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

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