Equivalent of mysql_insert_id() for ms sql server

Question

Possible Duplicate:
SQL: How to get the id of values I just INSERTed?

For PHP, What's equivalent of mysql_insert_id() for sql server 2012?

sqlsrv_insert_id() does not seem to exist.

Say this is the code

  if ($result) {
            // get user details 
            $uid = mysql_insert_id(); // last inserted id
            $result = mysql_query("SELECT * FROM users WHERE uid = $uid");
            // return user details
            return mysql_fetch_array($result);
        } else {
            return false;
        }

for mysql, how should I do it for sql server?

PDO has [lastInsertId](http://www.php.net/manual/en/pdo.lastinsertid.php), might be a good idea to switch to PDO? — fvu, Oct 14 '12 at 08:40

Jonathan Levison · Accepted Answer · 2012-10-14T09:09:29.340

7

Check this out: http://fr2.php.net/manual/en/book.mssql.php Over there at the comments you have the php syntax at the comments:


function mssql_insert_id() { 
    $id = 0; 
    $res = mssql_query("SELECT @@identity AS id"); 
    if ($row = mssql_fetch_array($res, MSSQL_ASSOC)) { 
        $id = $row["id"]; 
    } 
    return $id; 
}

edited Oct 14 '12 at 09:09

answered Oct 14 '12 at 08:41

Jonathan Levison

2,617
1
17
22

mysql_fetch_array($res, MYSQL_ASSOC)..use mysql for sqlsrv? – william007 Oct 14 '12 at 08:46
No, that makes little sense, i copied and pasted from the link i referenced, I think they had a typo there, I will fix what I copy-pasted, please let us know if it works :) – Jonathan Levison Oct 14 '12 at 09:08

score 1 · Answer 2 · answered Oct 14 '12 at 08:42

1

Or query it:

SELECT `column_id` FROM `table` ORDER BY `column_id` DESC TOP 1

TOP is the MySql equivalent of LIMIT

answered Oct 14 '12 at 08:42

Mike de Klerk

11,202
8
48
73

Equivalent of mysql_insert_id() for ms sql server

2 Answers2