$sql = "SELECT FirstName, LastName FROM SomeTable";
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
    die( print_r( sqlsrv_errors(), true) );
}

while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
      echo $row['LastName'].", ".$row['FirstName']."<br />";
}

sqlsrv_free_stmt( $stmt);

$tsql_callSP = "{call usp_sessions_set_terms( ?, ?, ? )}";   

$id_language = $id_language;  
$term = '';  
$native_term = '';  

$params = array( 
array($id_language,SQLSRV_PARAM_IN), 
array($term, SQLSRV_PARAM_OUT),  
array($native_term, SQLSRV_PARAM_OUT)               
);   

/* Execute the query. */  
$stmt3 = sqlsrv_query( $conn, $tsql_callSP, $params);   

if( $stmt3 === false ) {       
echo "Error in executing statement 3.\n";       
die( print_r( sqlsrv_errors(), true)); }   

/* Display the value of the output parameters. */   
while ($obj=sqlsrv_fetch_object($stmt3)) {       
// SET PARAMETERS - SET TERMS      
echo $obj->term;  
}  

/*Free the statement and connection resources. */  
sqlsrv_free_stmt( $stmt3);  

		$sql = "{call functionName(?)}";

		$template_cls_id = '-1'; // мой параметр

		$params = array(
                                 array($template_cls_id, SQLSRV_PARAM_IN)
                                 );

		$result = sqlsrv_query($connect, $sql, $params);

		if( $result === false ) {       
			echo "Ошибка запроса";       
		die( print_r( sqlsrv_errors(), true)); 
	}     

	if(sqlsrv_has_rows($result)){
		while($row = sqlsrv_fetch_array($result)){ 
			return $row; 
		}
	}
	else{ echo "<br/>Не найдено результата.";}
	
	sqlsrv_close(self::$link);