problems with store procedure

  • Hello, How can I pass or define a variable type table to a store procedure in SQL server?

    thanks

  • Sorry you cannot do this directly as table data type is not supported as of yet. However I haven't tried this but it may work the same or at least you can use an actual temp table and I know it will. But create you table variable outside the SP and in the same connection without dropping the variable call the variable directly. It may not work with the data type table but if you CREATE TABLE a temp table as long as the connection isn't dropped it will remain existance and the SP can see it.

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

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

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