note 46026 added to function.mssql-query

From: Date: Mon, 27 Sep 2004 12:02:56 +0000
Subject: note 46026 added to function.mssql-query
Groups: php.notes 
Request: Send a blank email to php-notes+get-77430@lists.php.net to get a copy of this message
In response to post from jesse at lostangel dot net from 18-Sep-2002: INSERT ... SELECT @@IDENTITY may NOT work as desired! While running multiple queries at the same time, you will get the last identity value generated, somewhere in your database. If you need to know the identity value generated by your INSERT statement, use SCOPE_IDENTITY(). ---- Manual Page -- http://www.php.net/manual/en/function.mssql-query.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+46026 Delete -- http://master.php.net/manage/user-notes.php?action=delete+46026&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+46026&report=yes Search -- http://master.php.net/manage/user-notes.php

« previous php.notes (#77430) next »