Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: Using TABLE Variables
 Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

Cybernetic Yak Master

11752 Posts

Posted - 06/20/2007 :  07:01:23  Show Profile  Visit spirit1's Homepage  Reply with Quote
the possiblity to pass in rowset as a parameter is said to come in SQL Server 2008.

Causing trouble since 1980
Go to Top of Page

Premature Yak Congratulator

22864 Posts

Posted - 06/20/2007 :  09:03:58  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
Originally posted by pvten

Originally posted by gwhiz

Has anyone else noticed an additional limitation to the table variable.

Hi all,
I heard that table variable can be used with Stored Procedures (SP), function.. but
When I'm trying to use table variable as a parameter (in both IN or OUTPUT type) for may SP, but I received an error..(??)

So my question is: CAN WE USE IT AS A PRAMETER IN SP ??

Ten PV

Not directly. You can simulate


Failing to plan is Planning to fail
Go to Top of Page

Starting Member

6 Posts

Posted - 07/20/2010 :  10:16:02  Show Profile  Reply with Quote
Table variables are not memory variables, they are stored in tempdb just like temp tables.

Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000