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 !!

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1137

---

what is difference between NULL and ISNULL in SQL Server 2008?

1016

---

How to remove duplicate rows from table?

1250

---

What type of locking occurs during the snapshot generation? : sql server replication

1332

---

How to end a stored procedure properly in ms sql server?

1092

---

How to check parameter value in stored procedure sql server?

973

---

What are dml (data manipulation language) statements in ms sql server?

983

---

What are the rules to use the rowguidcol property to define a globally unique identifier column?

1021

---

What do you know about normalization and de- normalization?

925

---

What is the bookmark lookup and rid lookup?

998

---

What are the requirements for sql server 2016?

882

---

When I run the sql server 2000 setup, it just hangs. What do I do?

1082

---

Why do we backup Active Directory ?

1043

---

What is a with(nolock)?

984

---

How do you implement session management in SQL Server mode?

1107

---