<div>
Ya, there really isn't.....Depending on how you're running the query, you can also use<br />
<br />
SET ROWCOUNT yourlimivaluehere<br />
SELECT * From sg_questions<br />
<br />
<br />
Brett
</div>


Ya, there really isn't.....Depending on how you're running the query, you can also use

SET ROWCOUNT yourlimivaluehere
SELECT * From sg_questions


Brett

<div>
<div class="content wysiwyg-content">
I am using MSSQL as a backend and I want to put pagination in the pages that display data.<br />
<br />
This is the statement that I have so far;<br />
<br />
$query = &quot;SELECT * FROM sg_questions LIMIT '$limitvalue', '$limit'&quot;;<br />
<br />
&quot;LIMIT&quot; seems to be what MSSQL doesn't like.<br />
<br />
What is the MSSQL equivalent to MySQLs LIMIT? 
</div>
</div>


I am using MSSQL as a backend and I want to put pagination in the pages that display data.

This is the statement that I have so far;

$query = "SELECT * FROM sg_questions LIMIT '$limitvalue', '$limit'";

"LIMIT" seems to be what MSSQL doesn't like.

What is the MSSQL equivalent to MySQLs LIMIT? 

MSSQL equivalent to MySQLs LIMIT

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.