What is the difference between Temporary table variable and
a Table variable?
Or
Which Table variable I should use inside Stored procedure?
- 3 Answers
- 7147 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
Explain Geography datatype in SQL Server
What is trigger explain with program?
What are different types of database indexes?
How to find the second highest salary of an employee?
Difference between aggregate functions of sql?
what is dbcc? : Sql server database administration
Tell me about pre-defined functions of sql?
What is the index requirement in SQL Azure?
What is acid properties?
What is update locks?
What the different topologies in which replication can be configured?
What is use of except clause? How does it differ from not in clause?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What are different types of raid levels?
How to define output parameters in stored procedures?
