What is the difference between Temporary table variable and
a Table variable?
Or
Which Table variable I should use inside Stored procedure?
- 3 Answers
- 8565 Views
- Microsoft, TCS, Techastrum, I also Faced
- E-Mail Answers
Answer Posted / oliva
There are major theoretical differences between temporary tables:
Temp table will show below
create table #T (…)
Table var will show below
And table variables:
declare @T table (…)
scope of table var is only inside the Store Procedure.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What are the different SQL Server Versions you have worked on?
What is subquery? Explain the properties of a subquery?
How raid can influence database performance?
What is self contained sub query?
How can you append an identity column to a temporary table?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is a scheduled job or what is a scheduled task?
How do I find the sql server version?
Disadvantages of the indexes?
Why use identity in sql server?
Why and when do stored procedure recompile?
Can we shrink data file in sql server?
What is the difference between upgrade and migration in sql server?
Can we do dml on views?
Why should you use or avoid select * statements?
