Answer / Anuj Singh

To multiply all values of a single column in Sybase, you can use the built-in aggregate function SUM with a self-join and a subquery:

SELECT column_name * (SELECT SUM(column_name) FROM your_table) as total FROM your_table;

How do I pipe the output of isql to a file in sybase?

1 Answers  

---

What are the catches?

1 Answers  

---

How to compute database fragmentation in sybase?

1 Answers  

---

Is data insertion is fast in SYBASE IQ if we have more indexes on a table?

3 Answers   FIC,

---

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

1 Answers  

---

How do check the current running processes?

1 Answers  

---

Why am I running out of locks on the replicate side in sybase ?

1 Answers  

---

Differentiate between db-lib and ct-lib?

1 Answers  

---

What data types does sybase support?

1 Answers  

---

We have lost the sa password, what can we do?

1 Answers  

---

When should I execute an sp_recompile in sybase?

1 Answers  

---

How do I exclude a column in sybase?

1 Answers  

---