PHP 使用Microsoft Drivers for PHP for SQL Server 操作 SQL Server
插入数据获取last insert id
$sql = "INSERT INTO table (column ) values ('1'); SELECT SCOPE_IDENTITY()";
$stmt = sqlsrv_query($this->conn, $sql);
sqlsrv_next_result($stmt);
sqlsrv_fetch($stmt);
return sqlsrv_get_field($stmt, 0);
分页
$sql = "select * from (
select *,ROW_NUMBER() OVER (ORDER BY sci.Id) as rank
from table where StudentId = ? ) as t where t.rank between $minNum and $maxNum";
$stmt = sqlsrv_query($this->conn, $sql, array($studentid));