Re: Get Last ID Inserted
| From: | David Elliott | Date: | Thu, 21 Nov 2002 16:03:12 +0000 |
| Subject: | Re: Get Last ID Inserted | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23566@lists.php.net to get a copy of this message | ||
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello Adam
On 21 November 2002 at 10:47:15 -0500 (which was 15:47 where I live) Adam
Voigt wrote
> Using Microsoft SQL does anyone know how to get the id of the row that
> you just inserted without clumsily trying to select the id back based on
> the same criteria of your insert (which might be overlapping)?
select @@identity
- --
Cheers, _______________________________________________
David | David Elliott | Software Engineer |
_________________________| david@elliott.uk.com | PGP Key ID 0x650F4534 |
| No dinner with Mel Gibson?! - Dot Warner |
-----BEGIN PGP SIGNATURE-----
Version: 6.5.8ckt http://www.ipgpp.com/
iQA/AwUBPd0DwfmK8eZlD0U0EQI3fACgsv52o5AvhuroJIVYblYXTnkiDZYAn2Ao
y1AeA+bR4KPOwZhZTAa2x7kr
=f/lr
-----END PGP SIGNATURE-----