You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

0 Answers  

---

What is a trigger what are the advantages of trigger?

0 Answers  

---

What methods do you follow to protect from sql injection attack?

0 Answers  

---

What do you understand by recursive stored procedures?

0 Answers  

---

Can we create clustered index on non primary key column

20 Answers   ABC, CTS,

---

What is the difference between insensitive and scroll cursor?

0 Answers  

---

Can we use having clause without group by?

0 Answers  

---

What is difference between views and stored procedures?

0 Answers  

---

What are the disadvantages of indexes?

0 Answers  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

Explain what are magic tables in sql server?

0 Answers  

---

SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

1 Answers   CarrizalSoft Technologies,

---