Answer / Sunny Aggarwal

To remove row affected and dashes in Sybase, you can use the REPLACE function. For example, to remove dashes from a varchar variable named str, you would do: DECLARE @str VARCHAR(50) = '--example--'; SELECT REPLACE(@str, '-', '') as result.

How would you configure identities in sybase?

1 Answers  

---

You need to remove duplicate rows from a sybase table. How would you do that?

1 Answers  

---

Explain index covering? List its merits.

1 Answers  

---

What is ceiling()?

1 Answers  

---

What is replication in sybase?

1 Answers  

---

How would you lock a table in sybase? What text command will you use for it?

1 Answers  

---

What will happen if we create more indexes on a sysbase iq table?

1 Answers  

---

How to save space when inserting rows monotonically?

1 Answers  

---

Explain the role of replication server in sybase.

1 Answers  

---

What is cmaxpktsz good for in sybase?

1 Answers  

---

What is coalesce in sybase?

1 Answers  

---

When you change a database option when will it come into effect?

1 Answers  

---