problems with store procedure

• oigo

  SSC-Addicted

  Points: 422

  More actions

  June 7, 2002 at 4:47 pm

  #101165

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

  thanks

• Antares686

  SSC Guru

  Points: 125444

  More actions

  June 7, 2002 at 8:12 pm

  #430535

  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)