Tech or Treat! Write an article about your scariest tech disaster to win gadgets!Learn more

x
?
Solved

What is Sql Server  Table Variable ? How do we use it and when ??

Posted on 2011-02-12
3
Medium Priority
?
347 Views
Last Modified: 2012-06-21
What is Sql Server  Table Variable ? How do we use it and when ??
0
Comment
Question by:N_Sri
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 70

Assisted Solution

by:Éric Moreau
Éric Moreau earned 800 total points
ID: 34880302
0
 
LVL 41

Accepted Solution

by:
Sharath earned 1200 total points
ID: 34880368
like scalar variables which can hold scalar data, you can declare table variables to hold the tabular data.  table variables are like temp tables but there are few differentiating factors between both of them.

you can use table variables to store the intermediate data from your queries and use those table variables further in your code.

http://odetocode.com/code/365.aspx
http://www.sqlteam.com/article/using-table-variables
http://msdn.microsoft.com/en-us/library/ms188927.aspx
0
 

Author Closing Comment

by:N_Sri
ID: 34930266
ty
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

647 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question