Video: Using the TABLE Data Type in SQL SERVER: ASP Alliance

ASP.NET Tutorials » Video: Using the TABLE Data Type in SQL SERVER

Not Logged In. Login

AspAlliance
Register
Edit My Profile
Author List
Write for Us
About AspAlliance
Contact Us
Privacy Policy
Link To Us
Advertise

Subscribe
Free Newsletter
Newsletter Archive
RSS Syndication

Print Add To Favorites Email To Friend Rate This Article
Video: Using the TABLE Data Type in SQL SERVER

page 2 of 2

by Mohammad Azam
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 14671/ 50

Article Contents:

SQL SERVER TABLE Variable can be used to store the results of the query.
The TABLE variable can be used like any other SQL SERVER table with few exceptions.
The TABLE variable gives performance benefits over the temporary variable.
The TABLE variable can be returned from the SQL SERVER Function.

User Comments

Title: Table Data Type in Sql 2005
Name: Ajay Chaurasia
Date: 2008-08-08 7:21:26 AM
Comment:
Describe by Example.

Community Advice: ASP | SQL | XML | Regular Expressions | Windows