What is the difference between temp table and table variable?
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
What is the ‘fillfactor’?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
How to drop existing indexes in ms sql server?
Which tcp/ip port does the sql server run on? How can it be changed?
What is plan freezing?
What is a dbms wizard?
What command do we use to rename a db, a table and a column?
Do you know concepts and capabilities of sql server?
What is coalesce in sql server?
What are the types of resultset?
Explain the properties of sub-query in sql server?
How to find the version of sql server? : sql server database administration
What are three major types of constraints?
What is the difference between createstatement and preparedstatement?
Tell me about joins in database system and explain each in detail.