How to throw custom exception in Stored Procedure?

0 Answers   MCN Solutions,

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---

What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  

---

What are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,

---

in how many ways we can use count()

2 Answers  

---

How many primary keys are possible in a table?

0 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

Explain subquery and state its properties?

0 Answers  

---

what is call by value & call by reference ?

2 Answers   Cap Gemini,

---

How do you connect 100 files as a flat file sources in one package of SSIS?

2 Answers  

---

Which is better statement or preparedstatement?

0 Answers  

---

How many columns can exist together per table?

0 Answers   Cap Gemini,

---