What is the difference between temp table and table variable?
Answer Posted / samba shiva reddy . m
temp tables physically exists in temp DB
but temp variables does not exists.
| Is This Answer Correct ? | 4 Yes | 13 No |
Post New Answer View All Answers
How to provide column names in insert statements in ms sql server?
What is user-defined functions? What are the types of user-defined functions that can be created?
What is GUID in sql server?
List out the difference between union and union all in sql server?
Why SQL Agent is used?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Can we insert data if clustered index is disabled?
Explain candidate key, alternate key, and composite key?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What is the purpose of data source?
Tell me something about security and sql azure?
What is the difference between grant and with grant while giving permissions to the user?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What is the difference between ‘having’ clause and a ‘where’ clause?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?