What is the difference between Temporary table variable and
a Table variable?
Or
Which Table variable I should use inside Stored procedure?
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 start and end transact-sql statements?
List out the different types of locks available in sql server?
How to delete existing triggers using "drop trigger"?
What are trace flags and mention a few common trace flags used with sql server?
What are sql server procedures?
How you can add messages to the nt event log from within a stored procedure?
How you can get a list of all the table constraints in a database? : Sql server administration
Explain about system stored procedure?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What is the difference between osql and query analyzer?
What is the tcp/ip port on which sql server runs?
How can I check if a view exists in a sql server database?
Explain “row_number()” in sql server with an example?
How do I view a stored procedure in sql server query?
What are the different types of columns types constraints in the sql server?