You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

0 Answers  

---

How to customize error conditions.

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

0 Answers  

---

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

0 Answers  

---

Explain the rollup operator?

0 Answers  

---

---

How would you design a database for an online site, which would average a million hits a day?

0 Answers  

---

Explain about network model?

0 Answers  

---

Write the fastest query to find out how many rows exist in a table?

0 Answers  

---

Which four data types cannot be used as a return type from a user-defined function?

0 Answers  

---

what is Normalization?

6 Answers   TCS,

---

What is the maximum length of an extended property?

0 Answers  

---

Can an extended stored procedure be called from inside a user-defined function?

0 Answers  

---