What is the difference between temp table and table variable?
Answer Posted / rathikapoobalan
1. If we use Temporary Table in a stored procedure, We
should drop it at the end.
It is not necessary in the case of Table variable.
2. In Table variable we can hold maximum of 20000 records
only. If it exceeds, we can use temporary table
Is This Answer Correct ? | 11 Yes | 16 No |
Post New Answer View All Answers
What is difference between materialized view and view?
What is after dml trigger?
What is a covered index?
How to execute a stored procedure in ms sql server?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
List some of the rules that apply to creating and using a ‘view’
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
what exactly sql injuction.how to overcome.....
Explain about thread and memory management process of SQL?
How does the report manager work in SSRS?
Give an example of SQL injection attack ?
Tell me what is log shipping?
What is the use of floor function in sql server?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?