Answer Posted / jayakumar

Temporary tables are created in the tempdb database. To
create a temporary table, you must have created table
permission in tempdb.
You can create temp tables in 2 ways :
1. Create table #tablename
2. Create table tempdb..tablename

a).If you create the table as per the above mentioned ways,
the table will get dropped automatically when the
session/procedure ends or you drop it manually.
b).If you don’t use the above mentioned ways and use
only "create table table name" command in tempdb the table
will stay there as long as you drop in manually.
c).If you create a table in any other database other than
tempdb, it will not be a temp table.

Differentiate between replication server and sql remote?

887

---

Explain coalesce. What is the equivalent of oracle/db2 coalesce function in sybase?

786

---

How do I choose which tables to partition in sybase?

797

---

How to remove row affected and dashes?

832

---

How do I force an index to be used in sybase?

779

---

What is the drawbacks of normalization?

913

---

Is there any advantage of last_name varchar(50) over this last_name varchar(255)?

852

---

Must I use multiple devices to take advantage of partitions in sybase?

857

---

What is replication server? What is its role in sybase?

880

---

Alternative to row at a time processing in sybase?

725

---

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

986

---

How do the blocker processes exist internally in sybase?

831

---

How to manually drop a table in sybase?

915

---

Is sybase open source?

822

---

What is open server in sybase?

758

---