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).

Differences between clustered and non-clustered in sybase?

949

---

Explain timestemp datatype in sybase.

1028

---

What do you mean by mainframe connect tool in sybase?

945

---

What do you mean by deferred update in sybase?

982

---

explain engines?

954

---

Which version of open client works with which ase in sybase?

981

---

How would you configure identities in sybase?

1105

---

How would you replicate col = col + 1 in sybase?

1117

---

Explain coalesce.

987

---

What is asa ultralite in sybase?

984

---

Are there any alternatives to isql in sybase?

994

---

Explain 'forcing an index' concept.

968

---

State some of the criticism about sybase iq?

967

---

Explain defncopy and it's usage?

1016

---

How to start and stop sybase database in linux sap?

986

---