note 46026 added to function.mssql-query
| From: | dennisat-nospam-darknoised0tde at osu1 dot php dot net | 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