Answer Posted / soorai ganesh

Should Implement ROW_NUMBER() method.

Just take this Example.

Create table emp(empid int, ename varchar(50),salary numeric
(9,2)

Insert into emp values(1,'Employee1',10000)
Insert into emp values(2,'Employee2',20000)
.
.
Insert into emp values(10,'Employee10',100000)

Consider the above table which have 10 records. Now u
want to select 5,6,7 Rows in this table. Just try this
query.

SELECT E.EmpID,E.EName,E.Salary FROM
(
SELECT ROW_NUMBER() OVER(ORDER BY EmpID ASC) AS Rno, *
FROM emp
) E
WHERE E.Rno >= 5 and E.Rno <= 7

Thats all.
If anyone have other such good idea kindly share........

How to integrate the ssrs reports in application?

962

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1103

---

How to provide default values to stored procedure parameters?

1039

---

What is bit data type?

1012

---

What are the disadvantages of using the stored procedures?

1077

---

What are the differences between ms sql server & oracle?

1036

---

Can we do dml on views?

939

---

How to select an exiting database using mssql_select_db()?

961

---

How to move database physical files in ms sql server?

1006

---

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

958

---

What is collation sensitivity? Explain different types.

990

---

What part does database design plays a role in performance of an sql server-based application?

960

---

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2742

---

How can we check the sql server version?

1031

---

What is a partition function in sql server?

1091

---