在查询中带有“declare”的PDO Dblib返回false

Question

Let's check this little piece of code:

$p = new PDO('dblib:host=HOST;dbname=DBNAME',USER,PASS);
$sql = "
declare @tutu int = 100;
select @tutu [tutu];
";
$stmt = $p->prepare($sql);
$stmt->execute();
var_dump($stmt->fetch(PDO::FETCH_ASSOC));

This returns:

bool(false)

Answer 1

use nextRowset();

$p = new PDO('dblib:host=HOST;dbname=DBNAME',USER,PASS);
$sql = "
declare @tutu int = 100;
select @tutu [tutu];
";
$stmt = $p->prepare($sql);
$stmt->execute();
$stmt->nextRowset();
var_dump($stmt->fetch(PDO::FETCH_ASSOC));

This returns:

array(1) {
  [0]=>
  array(1) {
    ["tutu"]=>
    string(3) "100"
  }
}