hey guys
i develop a news portal but i'm quite new in SQL Server, i know in MYSQL Server we have 'LIMIT' statement which i code sth like this:
SELECT fields FROM table decs LIMIT 10,5
it will read records 5 up to 10.
the thing i wanna do here, is to limit the number of news shown in each page, (i.e for example 10 news for each page, pagination)
how do i do that, last time i checked, there is not a 'LIMIT' statement in SQL Server!
tnx in advance