Passing table variable or temp table as input parameter

Question

Passing table variable or temp table as input parameter

arctica82

Ten Centuries

Points: 1013
More actions
January 27, 2010 at 9:25 pm

#219985

I am working with SQL SERVER 2000,Is it possible to Pass table variable or temp table as input parameter to stored procedure?Can I define a table type input parameter for stored procedure.
Thanks

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

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

WayneS SSC Guru Points: 95460 More actions · Answer 1

arctica82 (1/27/2010)
I am working with SQL SERVER 2000,Is it possible to Pass table variable or temp table as input parameter to stored procedure?

Not in SQL 2000.

Can I define a table type input parameter for stored procedure.
Thanks

Not in SQL 2000.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

vstitte SSCarpal Tunnel Points: 4475 More actions · Answer 2

You can load the data into a table and in the stored procedure reference this table. That should work.

Sergiy SSC Guru Points: 110208 More actions · Answer 3

Temp tables work perfectly for this purpose.

_____________
Code for TallyGenerator

joshgeake SSC Enthusiast Points: 132 More actions · Answer 4

Not in SQL 2000. Yes in SQL 2005/2008 though...

[url= http://www.geakeit.co.uk/2011/02/05/a-table-input-variable-in-a-stored-procedure-and-bypassing-must-declare-the-table-variable-msg-1087/%5D

http://www.geakeit.co.uk/2011/02/05/a-table-input-variable-in-a-stored-procedure-and-bypassing-must-declare-the-table-variable-msg-1087/%5B/url%5D

Garadin One Orange Chip Points: 29613 More actions · Answer 5

Alternatively, you can use XML and parse that into a temp table.

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. 😉

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]