Search code examples
phpsql-serverserverserver-side

Data from serverside not display

hello guys i try data use datatables from serverside (SQL Server) if me use code my data not found or not availaible. this is my code

$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]."   ".$requestData['order'][0]['dir']."   LIMIT ".$requestData['start']." ,".$requestData['length']."   ";

please help me

Solution

  • Use OFFSET and FETCH in SQL Server OFFSET FETCH Clause.

    SELECT * FROM table ORDER BY column OFFSET 10 ROWS FETCH NEXT 5 ROWS ONLY;

    Possible duplicate: LIMIT 10..20 in SQL Server.