diff options
| author | Rick Ellis <rick.ellis@ellislab.com> | 2007-06-11 07:33:21 +0200 |
|---|---|---|
| committer | Rick Ellis <rick.ellis@ellislab.com> | 2007-06-11 07:33:21 +0200 |
| commit | 1db17b57686911fea83103509c1438cbe1e545da (patch) | |
| tree | 58ac929b95c7a9417db68821f6f421f0dab6080e /system/database | |
| parent | b628e14f4e5ed47488a2dc2b861a2deeeaae9791 (diff) | |
Diffstat (limited to 'system/database')
| -rw-r--r-- | system/database/drivers/mssql/mssql_driver.php | 50 |
1 files changed, 43 insertions, 7 deletions
diff --git a/system/database/drivers/mssql/mssql_driver.php b/system/database/drivers/mssql/mssql_driver.php index ef66e3f3a..aef8da926 100644 --- a/system/database/drivers/mssql/mssql_driver.php +++ b/system/database/drivers/mssql/mssql_driver.php @@ -222,15 +222,51 @@ class CI_DB_mssql_driver extends CI_DB { // --------------------------------------------------------------------
/**
- * Insert ID
- *
- * @access public
- * @return integer
- */
+ * Insert ID
+ *
+ * Returns the last id created in the Identity column.
+ *
+ * @access public
+ * @return integer
+ */
function insert_id()
{
- // Not supported in MS SQL?
- return 0;
+ $ver = self::_parse_major_version($this->version());
+ $sql = ($ver >= 8 ? "SELECT SCOPE_IDENTITY() AS last_id" : "SELECT @@IDENTITY AS last_id");
+ $query = $this->query($sql);
+ $row = $query->row();
+ return $row->last_id;
+ }
+
+ // --------------------------------------------------------------------
+
+ /**
+ * Parse major version
+ *
+ * Grabs the major version number from the
+ * database server version string passed in.
+ *
+ * @access private
+ * @param string $version
+ * @return int16 major version number
+ */
+ function _parse_major_version($version)
+ {
+ preg_match('/([0-9]+)\.([0-9]+)\.([0-9]+)/', $version, $ver_info);
+ return $ver_info[1]; // return the major version b/c that's all we're interested in.
+ }
+
+ // --------------------------------------------------------------------
+
+ /**
+ * Version number query string
+ *
+ * @access public
+ * @return string
+ */
+ function _version()
+ {
+ return "SELECT @@VERSION AS ver";
}
// --------------------------------------------------------------------
|