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
- 8374 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 the need for indexing?
Define clusters?
How to query multiple tables jointly?
can you instantiate a com object by using t-sql? : Sql server database administration
What is read uncmmited?
What is the rdl file?
How to list all objects in a given schema?
What is the difference between for xml raw and for xml auto?
Why I have to use stored procedures?
Do you know what is a linked server in sql server?
List the different normalization forms?
What is the use of tempdb? What values does it hold?
Where is trigger in sql server?
How you can add messages to the nt event log from within a stored procedure?
What are various limitations of the views?
