Answer / Naz Mehdi

To find the time taken for a rollback in Sybase, you can use the SQL Server's built-in function @@TRANCOUNT and the system function GETDATE(). You would first execute your transaction, then check the value of @@TRANCOUNT to see if there are any open transactions. If there are, you can calculate the time taken for the rollback by subtracting the initial GETDATE() from the final GETDATE() after the rollback.

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

1 Answers  

---

Explain update statistics.

1 Answers  

---

What is the difference between natural join and equi join?

1 Answers  

---

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

1 Answers  

---

When should I execute an sp_recompile in sybase?

1 Answers  

---

Tempdb is full. How would you clear it?

1 Answers  

---

Compare join and subquery in performance?

1 Answers  

---

How do I connect to sybase?

1 Answers  

---

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

1 Answers  

---

How to remove row affected and dashes?

1 Answers  

---

Explain relationship between jdbc and sybase.

1 Answers  

---

Can you create your own sps for system wise?

1 Answers  

---