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  

---

Explain features and concepts of analysis services?

0 Answers  

---

What is the primary use of the model database?

0 Answers  

---

How many types of Outer Joins?What are they?

1 Answers  

---

How do you use a subquery to find records that exist in one table and do not exist in another?

0 Answers  

---

---

What are the different types of joins and what does each do?

2 Answers  

---

How to transfer Logins from SQL Server 2000 to 2005

2 Answers  

---

What is the impact on other user sessions when creating indexes?

0 Answers  

---

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

0 Answers   Accenture,

---

write an SQL query to list the employees who joined in the month of January?

0 Answers   Agilent, Amdocs,

---

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  

---

What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008

2 Answers   IBM,

---