$serverName = '192.xxx.xxx.xx';
$userName = 'usertest';
$userPassword = 'pwdtest';
$dbName = 'dbtest';
try{
$conn = new PDO("sqlsrv:server=$serverName ; Database = $dbName", $userName, $userPassword);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(Exception $e){
die(print_r($e->getMessage()));
}
$query = " SELECT * FROM tbl
ORDER BY field1 DESC
OFFSET 0 ROWS
FETCH NEXT 100 ROWS ONLY ";
$getRes = $conn->prepare($query);
$getRes->execute();
while($row = $getRes->fetch( PDO::FETCH_ASSOC ))
{
echo $row['field1']."<br />";
echo $row['field2']."<br />";
}