0

Class yii\db\mssql\SqlsrvPDO

All Classes | Methods | Constants
Inheritanceyii\db\mssql\SqlsrvPDO » PDO
Available since version2.0
Source Code https://github.com/yiisoft/yii2/blob/master/framework/db/mssql/SqlsrvPDO.php

This is an extension of the default PDO class of SQLSRV driver.

It provides workarounds for improperly implemented functionalities of the SQLSRV driver.

Public Methods

Hide inherited methods

Method Description Defined By
lastInsertId() Returns value of the last inserted ID. yii\db\mssql\SqlsrvPDO

Constants

Hide inherited constants

Constant Value Description Defined By
SQLSRV_ATTR_ENCODING 1000 A constant for the pdo_sqlsrv encoding attribute. Pass as a key in yii\db\Connection::$attributes. yii\db\mssql\SqlsrvPDO
SQLSRV_ENCODING_SYSTEM 3 A constant for ANSI (system code page) string encoding. Use with SQLSRV_ATTR_ENCODING to avoid the implicit nvarchar-to-varchar conversion that degrades performance on char/varchar indexed columns. yii\db\mssql\SqlsrvPDO
SQLSRV_ENCODING_UTF8 65001 A constant for UTF-8 string encoding. This is the pdo_sqlsrv default for PDO::PARAM_STR parameters. yii\db\mssql\SqlsrvPDO

Method Details

Hide inherited methods

lastInsertId() public method

Returns value of the last inserted ID.

SQLSRV driver implements yii\db\mssql\PDO::lastInsertId() method but with a single peculiarity:

  • when $sequence value is a null or an empty string it returns an empty string.
  • but when parameter is not specified it works as expected and returns actual
  • last inserted ID (like the other PDO drivers).
public string|false lastInsertId ( string|null $sequence = null )
$sequence string|null

The sequence name. Defaults to null.
return string|false

Last inserted ID value.

 

                public function lastInsertId(string|null $sequence = null): string|false
{
    if ($sequence === null || $sequence === '') {
        return parent::lastInsertId();
    }
    return parent::lastInsertId($sequence);
}