php - 当SQL Server 2014中发生数据库错误时，自动增量值将更改

Contract_id是主键及其自动增量值

我在将数据添加到数据库时使用sql server 2014和codeigniter，在将数据插入数据库时​​遇到错误。问题是日期格式问题。我已解决此问题并再次成功插入数据库。

但是问题是Autoincrement（主键）值正在跳过并且序列的Next值也正在更改。当前端出现数据库错误时如何停止跳过autoincrement值？

public function save_contract() { 

        date_default_timezone_set('Asia/Dubai');
        //$created_Dt        = '2019-07-03';
        $created_Dt        = date('Y-m-d H:i:s');
        $this->db->select('NEXT VALUE FOR contacts_seq as contractid');
        $query = $this->db->get();

        foreach ($query->result_array() as $row)
        {
           $contract_number = $row['contractid'];
           //echo $contract_number;
        }



    $data = array(
           'Contract_no' => $this->input->post('getcontract_no'). $contract_number,
            'status' => "active",
            'created_Dt' => $created_Dt
        );

 $insert_id = 0;
     if($this->db->insert("contract", $data)){
        $insert_id = $this->db->insert_id();
        }
       return $contract_number;

    }

创建的序列

CREATE SEQUENCE  contacts_seq AS INT
 START WITH 1
 INCREMENT BY 1

查看更多