Answer Posted / anil

Cursor allow row by row fetching records

Explain Reporting Life Cycle?

90

---

How do you use a subquery to find records that exist in one table and do not exist in another?

546

---

What is Sqlpaging in SqlServer 2005 ?

658

---

Explain table valued parameters in sql server? Why tvp used?

553

---

What is 3nf normalization form?

561

---

---

What is transaction server consistency?

543

---

What are different types of statements that are supported by sql?

592

---

Name three of the features managed by the surface area configuration tool? : sql server security

508

---

What is in place upgrade in sql server?

520

---

What are the new features are introduced in sql server 2012 reporting services?

107

---

What is sql server replication? : sql server replication

532

---

Explain few examples of RDBMS?

611

---

How many types of stored procedures are there in sql server?

556

---

How to delete duplicate rows?

546

---

What are a scheduled jobs?

534

---