What is a temp table? how to denote temp table?
Answer Posted / leena bejoy
Any table with name starting with '#' is automatically put
into tempdb database.
Temp tables allow developers to create and scan tables
within a stored procedure - and
have the tables totally isolated from all other database
connections. This is very
valuable when results need to be processed several times
within a loop, or when
a complex result set is expected (like a crosstab). Note
that temp table transactions
are logged within tempdb (exception: select into create
statements).
Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
How would you list objects in sybase?
Explain procedure cache and data cache in sybase.
How would you lock a table in sybase? What text command will you use for it?
What are the catches?
Tempdb is full. How would you clear it?
List similarities and differences between oracle & sybase.
How to save space when inserting rows monotonically?
Explain update statistics.
What are the operating systems in which sybase could take its presence?
Is sybase owned by sap?
What is sybase used for?
What is the difference between replication server and sql remote in sybase?
What is trace flags — 5101 and 5102 in sybase?
What are the advantages that you can get from mainframe connect in sybase?
How do I take advantage of table partitioning with bcp in sybase?