What is the difference between Temporary table variable and
a Table variable?
Or
Which Table variable I should use inside Stored procedure?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / jagadeesh
transation can be rollback in temptable
but in tablevaribale we cannot do this
Is This Answer Correct ? | 1 Yes | 0 No |
what is the main difference between after trigger and instead trigger.
What does set rowcount do?
SQL Server Performance Tuning for Stored Procedures & reducing debugging time?
1 Answers CarrizalSoft Technologies,
How do you persist objects, permissions in tempdb
What xml support does the sql server extend?
What does it mean to be in union?
Is it possible to update the views? If yes, how, if not, why?
How to run sql server 2005 books online on your local system?
In which situation you use Self joins?
1 Answers CarrizalSoft Technologies, HP, TCS,
Is sql server free?
What is the difference between a "where" clause and a "having" clause?
What is a recursive stored procedure in sql server?