-----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----- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
