Converting mysql server-side to mssql
Converting mysql server-side to mssql
jetuliao
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?
This discussion has been closed.
Answers
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