Answer Posted / renu

Row_number() works on SQL 2005 and upper version, if u r
trying it on 2000 it will not work.

Is mysql better than sql server?

771

---

Define full outer join in sql server joins?

694

---

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

769

---

How do I find query history in sql server?

706

---

How does recursive cte works in sql server?

748

---

Where do we use trace frag?

761

---

Can we call stored procedure in view in sql server?

701

---

How does a profiler work?

689

---

What do we have to check in database testing?

791

---

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

791

---

What does indexation mean?

740

---

What are page splits? : SQL Server Architecture

768

---

Explain where clause?

765

---

Which rendering formats are affected by the pagesize properties?

122

---

What is the federation in sql azure?

91

---