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

How to use clusters?

965

---

what is the system function to get the current user's user id? : Sql server database administration

1032

---

What are the different types of data sources in ssrs?

196

---

What is query optimization process?

1020

---

Describe in brief system database.

1019

---

What is meant by referential integrity?

1016

---

How to convert numeric expression data types using the cast() function?

1078

---

What are dml triggers and types of dml triggers?

985

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

1023

---

What is table valued function and scalar valued functions?

1098

---

Write a sql query to get zero records from a table having n number of records?

1182

---

List types of tables in SQL Azure?

126

---

What are the advantages of using third-party tools?

1001

---

What are different types of roles provided by ssrs?

152

---

What are the commands used in DCL?

1032

---