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

What are the different type of replication in sql server?

945

---

Explain mixed authentication mode of sql server?

1006

---

Explain the xml support sql server extends?

1000

---

What is the dbcc command and why is it used?

1011

---

How many databases can we create in a single server?

205

---

What are the system database in sql server 2005?

999

---

What are constraints?

969

---

What are the restrictions that views have to follow? : SQL Server Architecture

956

---

What are the key configuration files for sql server reporting services ?

165

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1049

---

How to modify the underlying query of an existing view?

946

---

How to connect php with different port numbers?

1026

---

How are the exceptions handled in sql server programming?

1020

---

What is Extended user-defined?

906

---

What is coalesce and check constraint in sql server?

1063

---