Restrict The Number Of Records From Query

Hi,
ive a table of over 90,000 records . is ther any method for restricting the number of records returned by a SELECT query
i want to implement a query system which will give me the first 50 records, next 50 ,... and so on
can ne body help ?Originally posted by baburajv
Hi,

ive a table of over 90,000 records . is ther any method for restricting the number of records returned by a SELECT query

i want to implement a query system which will give me the first 50 records, next 50 ,... and so on

can ne body help ?

select top 50 from table_name|||SELECT TOP 50 FROM TABLE_NAME

WILL RETURN THE TOP 50 ROWS FROM THE TABLE

HOW CAN I RETRIEVE THE NEXT 50 ROWS|||Originally posted by baburajv
SELECT TOP 50 FROM TABLE_NAME

WILL RETURN THE TOP 50 ROWS FROM THE TABLE

HOW CAN I RETRIEVE THE NEXT 50 ROWS

I think then u need to use temperory tables for it.|||select top NUMBER_OF_ROWS *
from table
where column NOT IN
(select top BEGIN_AT column
from table)

Restoring to new database doesn't change logical DB name

I created a new database from a restore backup method. The database file names did get updated with the new database name, but the logical file name still remains the old file name.
Do we have to manually change the logical file name in the new database?
what is the use of logical name?
Please help!

The logical file will not change while u restore a db. you have to change it explicitly

alter database gpx mODIFY FILE (NAME=oldLogicalFilename,NEWNAME=NewLogicalFilename)

Madhu

|||

what is the use of logical name?

The name to represent the database data file. The logical name for each file is contained in the name column

The logical design of the database, including the tables and the relationships between them, is the core of an optimized relational database. A good logical database design can lay the foundation for optimal database and application performance. A poor logical database design can hinder the performance of the whole system.

Restoring SQL 6.5 backup into SQL 2000 on Server 2000

Hi,
Does anyone know of the best method to restore a SQL 6.5 backup into SQL
2000?
Thanks.Can't do that. Get a 6.5 installation, restore it there and use the Upgradin
g Wizard that comes with
SQL Server 2000 to get the data into your 2000 installation. Or use script,
BCP, DTS or similar
method.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Millie" <Millie@.discussions.microsoft.com> wrote in message
news:C3B5CF7D-8515-4B48-B351-6865A5CBBA03@.microsoft.com...
> Hi,
> Does anyone know of the best method to restore a SQL 6.5 backup into SQL
> 2000?
> Thanks.|||However you can restore the backup to a SQL 7 install ( if you have one.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Millie" <Millie@.discussions.microsoft.com> wrote in message
news:C3B5CF7D-8515-4B48-B351-6865A5CBBA03@.microsoft.com...
> Hi,
> Does anyone know of the best method to restore a SQL 6.5 backup into SQL
> 2000?
> Thanks.

Restoring SQL 6.5 backup into SQL 2000 on Server 2000

Hi,
Does anyone know of the best method to restore a SQL 6.5 backup into SQL
2000?
Thanks.
Can't do that. Get a 6.5 installation, restore it there and use the Upgrading Wizard that comes with
SQL Server 2000 to get the data into your 2000 installation. Or use script, BCP, DTS or similar
method.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Millie" <Millie@.discussions.microsoft.com> wrote in message
news:C3B5CF7D-8515-4B48-B351-6865A5CBBA03@.microsoft.com...
> Hi,
> Does anyone know of the best method to restore a SQL 6.5 backup into SQL
> 2000?
> Thanks.
|||However you can restore the backup to a SQL 7 install ( if you have one.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Millie" <Millie@.discussions.microsoft.com> wrote in message
news:C3B5CF7D-8515-4B48-B351-6865A5CBBA03@.microsoft.com...
> Hi,
> Does anyone know of the best method to restore a SQL 6.5 backup into SQL
> 2000?
> Thanks.

Restoring SQL 6.5 backup into SQL 2000 on Server 2000

Hi,
Does anyone know of the best method to restore a SQL 6.5 backup into SQL
2000?
Thanks.Can't do that. Get a 6.5 installation, restore it there and use the Upgrading Wizard that comes with
SQL Server 2000 to get the data into your 2000 installation. Or use script, BCP, DTS or similar
method.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Millie" <Millie@.discussions.microsoft.com> wrote in message
news:C3B5CF7D-8515-4B48-B351-6865A5CBBA03@.microsoft.com...
> Hi,
> Does anyone know of the best method to restore a SQL 6.5 backup into SQL
> 2000?
> Thanks.|||However you can restore the backup to a SQL 7 install ( if you have one.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Millie" <Millie@.discussions.microsoft.com> wrote in message
news:C3B5CF7D-8515-4B48-B351-6865A5CBBA03@.microsoft.com...
> Hi,
> Does anyone know of the best method to restore a SQL 6.5 backup into SQL
> 2000?
> Thanks.sql