Answer Posted / samar

hi i had tried same but i am getting error

Server: Msg 195, Level 15, State 10, Line 1
'row_number' is not a recognized function name

here querry is

select row_number() over(order by Income_Verification_id
) from Dim_Income_Verification

plz reply !!

Do you know what are the ways available in sql server to execute sql statements?

1082

---

How to modify the underlying query of an existing view?

1031

---

How do I know if localdb is running?

1001

---

What is the sql profiler?

1001

---

What are scheduled tasks in sql server?

1148

---

What are the properties and different types of sub-queries?

1054

---

Can I save my report as html, excel or word? : sql server management studio

1013

---

Describe and explain about SQL native client?

1159

---

How many types of database relationship in sql server?

1108

---

What is b tree index?

968

---

What is a recursive stored procedure in sql server?

1247

---

What is the difference between a unique key and primary key?

1006

---

Differentiate between a having clause and a where clause.

1010

---

How to resolve the orphan use problem? : sql server security

1075

---

Where the sql logs gets stored? : sql server database administration

1014

---