Path: C:\
<?php
$sql="SELECT id_Agenda as agenda
,tp_Situacao as sit
,ip_Inclusao as ip_incl
,convert(varchar(17),dt_Inclusao,113) as dt_incl
,ip_Alteracao as ip_alt
,convert(varchar(17),dt_Alteracao,113) as dt_alt
,ip_Exclusao as ip_exc
,convert(varchar(17),dt_Exclusao,113) as dt_exc
FROM sitAgenda
ORDER BY id_Agenda";
$sql_auxiliar=sqlsrv_query($conn2,$sql,array(),array("Scrollable"=>"buffered"));
if( $sql_auxiliar === false )
{ if( ($errors = sqlsrv_errors() ) != null)
{
foreach( $errors as $error )
{ ECHO "SQLSTATE: ".$error[ 'SQLSTATE']."<br />código: ".$error[ 'code']."<br />mensagem: ".$error[ 'message']."<br />";
}
}
}
unset($sit);unset($aux);
while($sit = sqlsrv_fetch_array($sql_auxiliar, SQLSRV_FETCH_ASSOC))
{
$aux[$sit['agenda']][0] = trim($sit['sit']);
$aux[$sit['agenda']][1] = $sit['ip_incl'];
$aux[$sit['agenda']][2] = $sit['dt_incl'];
$aux[$sit['agenda']][3] = $sit['ip_alt'];
$aux[$sit['agenda']][4] = $sit['dt_alt'];
$aux[$sit['agenda']][5] = $sit['ip_exc'];
$aux[$sit['agenda']][6] = $sit['dt_exc'];
}
//var_dump($aux);
?>