UDF

  • Is it possible to call a function, pass it a table variable as a parameter, manipulate data in it and return it back?

    Thank you,

  • See "User-Defined Functions That Return a table Data Type" in SQL BOL.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • Passing a table variable to a UDF as a parameter is not possible , though i think this is a much needed feature

  • See "User-Defined Functions That Return a table Data Type" in SQL BOL.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

    [/quote]

  • Sorry I agree with GRN and made and error when I posted. My mistake.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • [Thank you. Let's wait until next version rolls out.]

    Sorry I agree with GRN and made and error when I posted. My mistake.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

    [/quote]

Viewing 6 posts - 1 through 5 (of 5 total)

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