Answer / divya kalra

Subqueries can often be re-written to use a standard outer
join, resulting in faster performance. As we may know, an
outer join uses the plus sign (+) operator to tell the
database to return all non-matching rows with NULL values.
Hence we combine the outer join with a NULL test in the
WHERE clause to reproduce the result set without using a
sub-query.

Answer / syed sajjad

Yes we can write using Common Table Expression (CTE). A Common Table Expression (CTE) is an expression that can be thought of as a temporary result set which is defined within the execution of a single SQL statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query.

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,

---

What is bcp? When does it used?

0 Answers  

---

Explain isolation levels that sql server supports?

0 Answers  

---

explain different types of jions with examples briefly?

1 Answers   Zensar,

---

When a primary key constraint is included in a table, what other constraints does this imply?

0 Answers  

---

What are the two authentication modes in sql server?

0 Answers  

---

What is statement level trigger?

0 Answers  

---

How do triggers work?

0 Answers  

---

Does an index slow down updates on indexed columns?

0 Answers  

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

0 Answers   IGT,

---

What does it mean to be in union?

0 Answers  

---

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 Answers  

---