Answer / Mukta Sagar

Using stored procedures instead of passing SQL queries directly from an application offers several advantages. These include improved performance, since the SQL Server can precompile and cache frequently used queries; increased security, since stored procedures can be granted execution rights to specific users or roles; and easier maintenance, as changes to a query only need to be made in one place (the stored procedure) instead of multiple places (each application using the query).

Explain about sybase 365?

1 Answers  

---

Explain timestemp datatype in sybase.

1 Answers  

---

How to connect to sybase database from linux?

1 Answers  

---

Can I use a named pipe to bcp/dump data out or in in sybase?

1 Answers  

---

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?

1 Answers  

---

What are triggers? Why do we use them? Diff types of triggers? What are magic tables?

1 Answers  

---

What is the default table size in sybase?

1 Answers  

---

What is the difference between compression level 0 1nd 9

2 Answers  

---

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

1 Answers  

---

What are the different types of (all page) locks in sybase?

1 Answers  

---

What is an advantage to using a stored procedure as opposed to passing an sql query from an application ?

1 Answers  

---

What is rollback trigger in a trigger?

1 Answers  

---