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
How to test a dml trigger in ms sql server?
What is the significance of master, tempdb and model databases?
Explain system functions or built-in functions? What are different types of system functions?
How can you fetch alternate records from a table?
What is logshipping and its purpose?
What is difference between sql and sql server?
What is the difference between a function and a stored procedure?
Tell me what is difference between view and materialized view?
What is the stuff and how does it differ from the replace function?
Scalability, Availability, Integration with internet, etc.)?
How to drop an existing stored procedure in ms sql server?
What is wide table?
What are the new features of sql server 2008 r2 reporting service?
What do you mean by an execution plan? How would you view it?
What is the syntax for encrypting a column in SQL Server?