Post reply

Call function passing in table variable

  • June 2, 2004 at 10:43 pm

    #85282

    Is it possible to call a function and pass in a table variable as a parameter? I have no joy trying this (or finding on Google etc). It might be possible but there might be some sytax variation required in within the function or the call.

    Hopefully someone can point me in the right direction. Thanks in advance. Grant

  • June 3, 2004 at 6:20 am

    #508809

    From BOL "CREATE FUNCTION" article arguments section

    Is the parameter data type. All scalar data types, including bigint and sql_variant, can be used as a parameter for user-defined functions. The timestamp data type and user-defined data types are not supported. Nonscalar types such as cursor and table cannot be specified.

  • June 6, 2004 at 1:13 am

    #509140

    Excellent - Thanks, I missed that in BOL. At least I can stop going nuts trying to get it going.

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

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