perl and sql server - per page

[teroy]

hi guys,
i was wondering how you guys deal with giving the user a per page option with a cgi script using perl and sql server.

When i use perl and postgres i use
select field from table limit $num offset $num


as far as i can tell..i can't find something similiar for sql server...ie an offset for the 'top' attribute in select.

Any ideas/suggestions would be most appreciated

 

[MikeLacey]

I'm not an SQL/Server person, but I think that this is one of the things that's easy in S/S. I remember a lot of questions in the Oracle forums about this:

"How do I select just the first ten results from an Oracle SQL query, like the S/S 'TOP' function?"

Have a look in the Oracle 5,6 and 7 forum, search on TOP. Or ask the question in the SQL/Server forum. Mike

"Experience is the comb that Nature gives us, after we are bald."

Is that a haiku?
I never could get the hang
of writing those things.