Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
marconi8
Yak Posting Veteran
73 Posts |
 Posted - 2003-05-03 : 08:43:35
|
| in my php when i want to get limited result set i do this$rs=$mssql_connection->SelectLimit($m_SQL,$numrows,$offset);but now i know that mssql can operate with dynamic sql instead of interbase, and i'am trying to use selectlimit in spwhat function can do limited select in mssql ?thanks |
|
|
marconi8
Yak Posting Veteran
73 Posts |
Posted - 2003-05-03 : 08:54:44
|
| for example SELECT TOP 2 * FROM TABLE_NAME is not really what i need, because i need offset tooi try to find in mssql two functions working in pair,limit and offset, i mean that, i can set limit and position , from which select statement must to start work.... |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
LIMIT SELECT STATEMENT