Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between temp table and table variable?
- 8 Answers
- 27392 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
Explain the benefits of user-defined functions?
What is sql server management studio? : sql server management studio
What is index fragmentation in ms sql server?
How to modify an existing stored procedure in ms sql server?
What is difference between rownum and row_number?
What are logical database components? : SQL Server Architecture
What are the database objects? : SQL Server Architecture
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
How to create database with physical files specified in ms sql server?
What are entities and relationships?
What are the source of constraints?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is blocking and how would you troubleshoot it? : sql server database administration
What is dknf in normalization form?
