Please start any new threads on our new site at http://forums.sqlteam.com. 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
Username:
Password:
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

spirit1
Cybernetic Yak Master

Slovenia
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
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22864 Posts

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

quote:
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
http://www.sommarskog.se/arrays-in-sql.html


Madhivanan

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

manub22
Starting Member

India
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.

links:
http://www.sqlservercentral.com/articles/Temporary+Tables/66720/
http://support.microsoft.com/default.aspx?scid=kb;en-us;305977&Product=sql2k
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-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000