Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between temp table and table variable?
- 8 Answers
- 26844 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
Can we delete data from a view?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What is a collation in ms sql server?
Where are stored procedures in sql server?
difference between Clustered index and non clustered index ?
What are the advantages to use stored procedures?
What are the main differences between #temp tables and @table variables and which one is preferred?
What is the difference between function and stored procedure in sql server?
What is a mutating table error and how can you get around it?
What is subreport?
How to create sub reports?
what are different types of backups available in sql server? : Sql server database administration
What is the current limitation of the size of SQL Azure DB?
Explain the dbcc pintable command when would you use it?
Explain sql delete command?
