If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

0 Answers  

---

How do you delete duplicate rows in sql server?

0 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

5 Answers   Aptech, HCL, Perpetual, SAIC,

---

explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

---

Explain the difference between delete,drop and truncate in SQL Server?

0 Answers   HCL,

---

---

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  

---

What is read uncmmited?

0 Answers  

---

How to apply cascading referential integrity in place of triggers?

0 Answers  

---

What is user-defined function?

0 Answers  

---

What action plan is preferred if sql server is not responding?

0 Answers  

---

What is the template in sql?

0 Answers  

---

Mention the different types of replication in sql server.

0 Answers  

---