Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Temporary table variable and
a Table variable?
Or
Which Table variable I should use inside Stored procedure?
- 3 Answers
- 8267 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
How to add an address record into adventureworkslt?
What are the limitations/drawbacks or ssrs 2008 r2?
How to delete duplicate rows?
In which tcp/ip port does sql server run? Can it be changed?
What is sql or structured query language?
What do you mean by data integrity?
tell me the disaster recovery plan
When I delete any data from a table, does the sql server reduce the size of that table?
What is primary key and example?
How to create an multi-statement table-valued function?
Explain a differential backup?
Explain about system database?
is there a column to which a default can't be bound? : Sql server database administration
How to count duplicated values in a column in ms sql server?
Difference between group by clause and having clause in SQL?
