What is the difference between temp table and table variable?
- 8 Answers
- 24700 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / prakash
Temp table create automatically when you create any data
table create you must mention there create temporary table.
Table variable is must declare in procedure when you crate
procedure.
| Is This Answer Correct ? | 1 Yes | 13 No |
Post New Answer View All Answers
Why de-normalization required?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What is difference between sql and sql server?
What is nested transaction?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
How to attach adventureworkslt physical files to the server?
Can the “if update (colname)” statement be used in a delete trigger?
What are the parts of a function?
What is the use of tempdb? What values does it hold?
Explain subquery and state its properties?
which backup strategy you are following at ur company
What is dynamic cursor in SQL SERVER?
What is row_number () and partition by in sql server?
Find first and last day of current month in sql server
How to create an identity column?
