what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  

---

What are transactions in sql?

0 Answers  

---

What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,

---

How to convert numeric values to integers in ms sql server?

0 Answers  

---

Explain triggers?

0 Answers  

---

---

What are truncate options available in sql server? : sql server database administration

0 Answers  

---

How you can minimize the deadlock situation?

0 Answers  

---

How to recompile stored procedure at run time?

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,

---

What to check if a User database is locked?

0 Answers   TCS,

---

Is it possible to call a stored procedure within a stored procedure?

0 Answers  

---

Do you know what are the restrictions that views have to follow?

0 Answers  

---