#32241 [Bgs]: Why not have mssql_insert_id function when use Microsoft sql server database!

ID: 32241 Updated by: fmk@php.net Reported By: kangtk at 163 dot com Status: Bogus Bug Type: Feature/Change Request Operating System: Windows2000 Server PHP Version: 4.3.10 New Comment: It is possible to obtain this value from the server with an explicit sql statement: INSERT INTO jobs (job_desc,min_lvl,max_lvl) VALUES ('Accountant',12,125) SELECT @@IDENTITY AS 'Identity' Previous Comments: ------------------------------------------------------------------------ [2005-07-27 11:12:48] tony2001@php.net The underlying library doesn't provide something like that, so PHP doesn't provide a wrapper. There is nothing we can do, ask MS about it. ------------------------------------------------------------------------ [2005-07-27 04:05:48] Daniel dot Spada at det dot wa dot edu dot au To expand on the previous poster. I have found that there is no such function mssql_insert_id() when using MS-SQL server. I am using PHP 4.3.10-15, with SQL server 2000. A mssql_insert_id function would be REALLY handy to assist in error checking etc. ------------------------------------------------------------------------ [2005-03-09 03:10:31] kangtk at 163 dot com Description: ------------ I can use this function mysql_insert_id to get the insert id when I connect with mysql database. But I cann't use the mssql_insert_id when I change the code to Microsoft Sql server databse. Can you explain something to me? Thanks. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=32241&edit=1