Why use identity in sql server?

1178

---

What is a coalesce function?

1254

---

What are the different subsets of sql?

1624

---

List the ways in which dynamic sql can be executed?

1066

---

What is subquery in sql?

1131

---

List some case manipulation functions in sql?

1094

---

Which sql server table is used to hold the stored procedure script?

1010

---

What is the significance of master, tempdb and model databases?

1134

---

Explain alternate key, candidate key and composite key in sql server?

955

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1388

---

How to find the second highest salary of an employee?

1230

---

What is the main difference between ‘between’ and ‘in’ condition operators?

1283

---

How to make a remote connection in a database?

1023

---

Can we write a distributed query and get some data which is located on other server and oracle database?

1285

---

Explain the first normal form(1nf)?

1081

---