Answer / sandeep

Main difference is the outer and inner querries are
independent each other. This executes inner querry for each
and every rows in outer querry. It is better to use joins
instead of sub querries where it is possible. But in some
cases we cud use subquerries

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

How to get last system shutdown time in Sql server when restarted system?

1 Answers  

---

Explain use of expression builder.

0 Answers  

---

what is the Ticketing tool used in Wipro technologies at Bangalore...???

0 Answers   Liquid Hub,

---

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

---

What is WITH CHECK OPTION

3 Answers   Karur Vysya Bank KVB,

---

What are the limitation of the Online Index Rebuild Operation?

1 Answers  

---

How to compare the top two records using sql?

0 Answers  

---

How to change the ownership of a schema in ms sql server?

0 Answers  

---

How to modify the underlying query of an existing view?

0 Answers  

---

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?

1 Answers  

---

How many types of cursors are there in SQL Server?

5 Answers   247Customer, CarrizalSoft Technologies,

---