Answer Posted / dinesh from a1-technology

1)online indexing only in sql 2005.
2)CLR Integration with sql server 2005.
3)xml datatype in sql 2005.
4)More faster than sql 2000.
5)Inbuilt with ASP.NET 2005.
6)GetDate() function also working in function in 2005 sql.

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1143

---

Do you know what are the steps to process a single select statement?

967

---

What are the different kinds of ssrs reports?

214

---

Can sql servers linked to other servers like oracle?

945

---

What is the difference between a view and a stored procedure?

1036

---

What is the difference between createstatement and preparedstatement?

938

---

Explain steps of normalization?

1002

---

What are exact numeric data types in ms sql server?

1073

---

what are cursors? : Sql server database administration

1060

---

What is the maximum size of column in sql server?

889

---

What are subqueries in sql server?

1120

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

983

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

1088

---

What is mean by candidate key?

1006

---

How do I find my localdb version?

985

---