Answer / Ankita Kumari

Drill Down and Drill Through are interactive features in reports that allow users to explore data further. However, they differ in how they work:nDrill Down: Allows users to navigate from a summary level of detail to detailed information within the same report.nDrill Through: Generates a new report based on a single row or record selection in the initial report.

Do you know query execution plan?

1 Answers  

---

What is difference between equi join and inner join?

1 Answers  

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

1 Answers   MCN Solutions,

---

I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,

2 Answers  

---

What is data source document?

1 Answers  

---

How to test values returned by a subquery with the in operator?

1 Answers  

---

What are sparse columns?

1 Answers  

---

What is query optimizer in sql server?

1 Answers  

---

Why do we use stored procedures in sql server?

1 Answers  

---

What is Command line parameters in PLSQL.?

1 Answers   MCN Solutions,

---

How to throw custom exception in Stored Procedure?

1 Answers   MCN Solutions,

---

What are the different types of backup avaible in SQL SErver

6 Answers   Emphasis, IBM,

---