Converting mysql server-side to mssql

Converting mysql server-side to mssql

jetuliaojetuliao Posts: 1Questions: 1Answers: 0

Hi I am trying to convert mysql server-side to mssql server siide I've managed to get the output but I was having issue in this code.

$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." offset ".$requestData['start']." fetch next ".$requestData['length']." rows only ";

Any thoughts?

Answers

  • allanallan Posts: 48,315Questions: 1Answers: 6,976 Site admin

    What trouble were you having with it? Perhaps you could be a bit more specific. Were you getting an error message for example? And what version of SQL Server are you using? Offset / fetch next was introduced in SQL Server 2012.

    Allan

Sign In or Register to comment.