Hi guys,
I'm trying to implement pagination for my script with MS SQL as the back-end DataBase. I tried to read on it and found the LIMIT function that's available in MySQL. Unfortunately, the LIMIT function is not available in MS SQL. Do you have any ideas how can I implement pagination?
TYIA,
Nil-Joe
---------------------
e.g.
<b>Previous</b> | <b>1</b> | <b>2</b> | <b>3</b> | <b>4</b> | <b>Next</b>
---------------------
I've done this with MySQL. I don't know how to do it with MS SQL.
I'm trying to implement pagination for my script with MS SQL as the back-end DataBase. I tried to read on it and found the LIMIT function that's available in MySQL. Unfortunately, the LIMIT function is not available in MS SQL. Do you have any ideas how can I implement pagination?
TYIA,
Nil-Joe
---------------------
e.g.
<b>Previous</b> | <b>1</b> | <b>2</b> | <b>3</b> | <b>4</b> | <b>Next</b>
---------------------
I've done this with MySQL. I don't know how to do it with MS SQL.