does physical index sort data

1 Answers  

---

What happens if null values are involved in string operations?

0 Answers  

---

What is the use of SCOPE_IDENTITY() function?

2 Answers  

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---

Explain collation?

0 Answers  

---

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,

---

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  

---

Scalability, Availability, Integration with internet, etc.)?

0 Answers  

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

---

can we have a nested transaction? : Sql server database administration

0 Answers  

---

What are the five major components of a dbms?

0 Answers  

---

Explain stored procedure?

0 Answers  

---