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

Explain the difference between numeric and decimal data types in sybase.

884

---

When are stored procedures compiled in sybase?

849

---

Explain relationship between jdbc and sybase.

906

---

When should I execute an sp_recompile in sybase?

897

---

How do check the current running processes?

953

---

What is ceiling()?

972

---

How can set the multipal database ?

2920

---

How to manually drop a table in sybase?

1016

---

How to view the log files in sybase?

929

---

Is sybase owned by sap?

899

---

How do I configure identities in sybase?

859

---

How do you check database space? What measures are there to increase the db space?

954

---

What mandatory options are required for bcp command utility?

934

---

Why place tempdb and log on low numbered devices?

835

---

List different types of locks in sybase?

979

---