Answer / Mahender Singh

Stored procedures in Sybase are compiled when they are first executed or created. If a stored procedure is modified, it will need to be recompiled for the changes to take effect.

You need to add a notnull column in a table by using alter command (without using default command). How would you do that?

1 Answers  

---

What is sybase used for?

1 Answers  

---

How can I execute dynamic sql with ase in sybase?

1 Answers  

---

How do I set ts role in order to run certain dbccs?

1 Answers  

---

What is the difference between natural join and equi join?

1 Answers  

---

How do I connect to sybase?

1 Answers  

---

How can I tell the datetime my server started?

1 Answers  

---

What mandatory options are required for bcp command utility?

1 Answers  

---

You need to purge data from audit database. What will you do?

1 Answers  

---

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

1 Answers  

---

What is the command for quitting from sybase?

1 Answers  

---

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

1 Answers  

---