Answer Posted / pavan

Hi, This answer is with respect Sybase ASE database

# temp-table

A temp table is created with a prefix of #. These are
session specific. That means if user-1 creates some temp
tables with #<some name> and logs out and then logs-in into
the database, he will not be able to see the #<table> which
he created.

Shareable temp-table

In turn, if the user creates tables in tempdb without
any "#" , then the table becomes shareable temp table.
These will remain in tempdb till the ASE is rebooted. If
the user logs-out and then logs-in , even in second
sessioin he can still access these table.

- Pavan

Explain the features of sybase.

965

---

Are you doing the updates from within a cursor?

1156

---

Explain defncopy and it's usage?

1016

---

For synchronizing the logins from lower version to higher version, just take the 11.9.2 syslogins structure, go to 12.5 higher version server?

855

---

State some of the criticism about sybase iq?

967

---

Can I run any transact-sql command on a partitioned table in sybase?

898

---

Differentiate between db-lib and ct-lib?

1022

---

How to check database size in sybase iq?

1039

---

Explanation about replication server software?

986

---

What are the operating systems in which sybase could take its presence?

952

---

Explain procedure cache and data cache in sybase.

948

---

How to pad with leading zeros an int or smallint in sybase?

895

---

How do I create a partitioned table that spans multiple devices in sybase?

826

---

Explain update statistics.

904

---

Is sybase a database? Explain.

1012

---