Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between temp table and table variable?
- 8 Answers
- 27185 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
Write a SQL query to delete a table?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What are Row versions of DataRow?
Explain some stored procedure creating best practices or guidelines?
what is the difference between delete table and truncate table commands? : Sql server database administration
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What are the advantages of passing name-value pairs as parameters?
Can You Use Data Mining Models In Ssrs?
Do you know what are acid properties?
How do I edit a procedure in sql server?
What is the process of normalising?
Explain system views?
What is de-normalization and what are some of the examples of it?
How we can refresh the view?
Can you explain about buffer cash and log cache in sql server?
