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

Do you know nested transaction?

1 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

Explain microsoft sql server functions?

1 Answers  

---

Give main differences between "Truncate" and "Delete".

1 Answers   HCL,

---

Will sql server 2005 allow you to reduce the size of a column?

1 Answers  

---

What is the cpu pressure?

1 Answers  

---

What is the difference between Triggers and Stored Procedure?

1 Answers   HCL,

---

What is key set driven?

1 Answers  

---

What samples and sample databases are provided by microsoft?

1 Answers  

---

How can we improve performance by using SQL Server profiler?

1 Answers   QuestPond,

---

Get Current System Date Time

2 Answers  

---

List all the types of user-defined functions?

1 Answers  

---