Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between temp table and table variable?
- 8 Answers
- 27050 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
What are the advantages of sql stored procedure?
How to configure and test odbc dsn settings?
Can foreign key be deleted?
What is partitioned view?
How to create a scrollable cursor with the scroll option?
How to drop an existing schema in ms sql server?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What is report snapshot?
Can you always create a cache of a report?
How to delete an existing row with delete statements in ms sql server?
Explain about Joins?
Explain sub-query?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
Is sql server a database?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
