Answer Posted / sd

Cursors allow row-by-row prcessing of the resultsets.

Types of cursors: Static, Dynamic, Forward-only, Keyset-
driven

What is the report builder?

131

---

What are four major operators that can be used to combine conditions on a where clause?

986

---

how to do partition in sqlserver

2413

---

what information is maintained within the msdb database? : Sql server administration

915

---

How would we use distinct statement? What is its use?

1024

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1209

---

Explain what are various ways to enhance the ssrs report?

992

---

How to view the error log for any specific instance? : sql server database administration

990

---

What is the sql server agent?

1034

---

What are the advantages of paper records?

907

---

How self join is different from outer join?

1063

---

What is bcp? When does it use?

874

---

Do you know what is openxml in sql server?

1017

---

Explain the properties of the relational tables?

940

---

What are different types of table joins?

964

---