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.

Explain about the features of sybase iq?

1063

---

Does table partitioning require user-defined segments in sybase?

858

---

How do I set ts role in order to run certain dbccs?

840

---

Can you create your own sps for system wise?

955

---

How do I tell which tables have identities in sybase?

918

---

Why not max out all my columns sybase?

889

---

How to check if sybase database is up and running?

916

---

What do you mean by sybase iq?

941

---

When should I execute an sp_recompile in sybase?

948

---

You need to manipulate varbinary columns in sybase. How would you do that?

1031

---

How do I exclude a column in sybase?

945

---

What is the default table size in sybase?

949

---

Explain the advantages of sybase iq.

948

---

How to swap a db device with another?

933

---

What are the main differences between 11.x and 12.x versions of sybase?

884

---