What is the difference between Temporary table variable and
a Table variable?
Or
Which Table variable I should use inside Stored procedure?
- 3 Answers
- 7170 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 is plan freezing?
How to get a list of columns in a view using the "sp_columns" stored procedure?
write an SQL query to list the employees who joined in the month of January?
How to convert binary strings into integers in ms sql server?
What are the kinds of subquery?
How to deploy the Report?
What are recommended options to be used while using db mirroring? : sql server database administration
what is a self join? Explain it with an example? : Sql server database administration
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What does indexation mean?
What is de-normalization and what are some of the examples of it?
Is mysql the same as sql server?
What are functions in the sql server?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
