What is the difference between temp table and table variable?
- 8 Answers
- 25598 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 use stored procedures in sql server?
Explain nested trigger in sql?
What is the difference between NOROW and LOCKROW?
What is a sql join?
Why olap is used?
Can you explain different types of locks in sql server?
Can you force a query to use a specific index?
Where are sql server usernames and passwords stored in the sql server?
How to execute a sql statement using odbc_exec()?
What are the general features of sql server management studio? : sql server management studio
What is a deadlock and what is a live lock?
What is difference statement and preparedstatement?
Can sql servers link to other servers like oracle?
What happens if null values are involved in datetime operations?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
