PHP - rowcount con select usando PDO y MsSql

$Prepare = $PDO->prepare($SqlCommand);

$Prepare->execute();

echo($Prepare->rowCount());

<?php

$dbh = new PDO("mysql:host=localhost;dbname=test", "user","pass", array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));

$prepare=$dbh->prepare("select * from test");

$params=array();

$prepare->execute($params);

$result=$prepare->fetchAll(PDO::FETCH_ASSOC);

echo "Hay un total de: ".count($result);

foreach($result as $row)

{

	echo "<br>".$row["Tipo"];

}

?>

$stmt = $this->pdo->prepare($sql);

     foreach ($data as $key=>$value){

         $stmt->bindValue($key,$value);

     }

     $stmt->execute();

     return $stmt->rowCount();

}