Answer Posted / payal nath

SELECT ROW_NUMBER() OVER(ORDER BY <FieldName>)
FROM <TableName>

How is sql used in sql server?

1020

---

How to insert multiple rows with one insert statement in ms sql server?

1132

---

how will add additional conditions in sql?

1114

---

How to provide default values to function parameters?

1148

---

what protocol both networks use? : Sql server database administration

980

---

Explain iaas, paas and saas?

90

---

What is normalization 1nf 2nf 3nf?

1064

---

how many layers of tcp/ip protocol combined of? : Sql server database administration

1006

---

What are the different types of replication are there in sql server 2000?

1046

---

What is the security principal at the database level that represents your session?

948

---

What is abstracting periodical?

953

---

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1068

---

is there a column to which a default can't be bound? : Sql server database administration

1022

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2354

---

Why use update_statistics command in sql server?

1064

---