1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,

---

Can another user execute your local temporary stored procedures?

0 Answers  

---

What is the difference between Stored Procedures and triggers?

0 Answers   HCL,

---

When do you think a developer should use sql server-based cursors?

0 Answers  

---

What is the difference between DATETIME2 and DATETIME?

0 Answers   Infosys,

---

---

What is the stuff?

0 Answers  

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

Do you know sql server 2008 introduces automatic auditing?

0 Answers  

---

How would you choose between a clustered and a non-clustered index?

0 Answers  

---

What are sql server functions?

0 Answers  

---

what is replication? where do u use Go Keyword?

1 Answers   Satyam,

---

Explain filtered indexes benefits?

0 Answers  

---