return TOP

Question

return TOP

gofrin

SSC Rookie

Points: 29
More actions
July 21, 2003 at 7:48 am

#358083

Hi,
I have this problem, I need show data from DB
on HTML page. But in DB I have lot or record,
so for this I need something that return from all select only TOP 100 record.
Is is posible do it withou set in all query
TOP 100 ?
Thanx

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Hi gofrin,

quote:
I have this problem, I need show data from DB
on HTML page. But in DB I have lot or record,
so for this I need something that return from all select only TOP 100 record.
Is is posible do it withou set in all query
TOP 100 ?

not sure if I understand.

You need a query for this. Well, in fact only if your table contains more than 100 records.

A query could look like

SELECT TOP 100 * (or field) FROM table ..

table could be a subquery, view or a table, but this is briefly explained in BOL in 'SELECT (described) -> Position 'Transact-SQL Reference'

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

gofrin SSC Rookie Points: 29 More actions · Answer 2

I understand, that I can use select TOP 100 * ...

but this filter I need for all query on DB. And I would like found some way where I not need add TOP 100 into each query....

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

Hi gofrin,

quote:
I understand, that I can use select TOP 100 * ...
but this filter I need for all query on DB. And I would like found some way where I not need add TOP 100 into each query....

unfortunately there isn't such a feature like MySQL's LIMIT command in SQL Server. However, even this you need to put into every query.

So, how do you access your data?

If you are doing this with ADO, maybe you can use the MaxRecords property of the ADO recordset object?

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Hans Lindgren SSChampion Points: 10496 More actions · Answer 4

Hi!

Try the T-SQL command 'SET ROWCOUNT 100' on all your connections and you never get more then 100 rows when doing your SELECTs. Though it still has to be executed somehow...

Regards, Hans!

P.S The ADO MaxRecords might do that implicitly so I guess Frank and me are speaking of the same thing :/

Edited by - hanslindgren on 07/22/2003 02:00:31 AM

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

Hi Hans,

quote:
Try the SET ROWCOUNT 100 on all your connections and you never get more then 100 rows when doing your SELECTs

thanks, I know I was missing something

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

gofrin SSC Rookie Points: 29 More actions · Answer 6

gofrin

SSC Rookie

Points: 29

July 22, 2003 at 2:11 am

#466330

Thanx exactly this I need