RE: [PHP] MSSQL Function like mysql_insert_id?

What would the actual query look like then? COuld you give an example? > > > > > Answered my own question. > > > > If anyone if wondering, > > > > add SELECT @@IDENTITY to your INSERT statement and you'll get the id. > > > > Thanks. > > > > Flint > > > > > -----Original Message----- > > > From: Flint Doungchak [mailto:Flint@netsolutionsllc.com] > > > Sent: Wednesday, July 19, 2000 5:15 PM > > > To: 'php-general@lists.php.net' > > > Subject: [PHP] MSSQL Function like mysql_insert_id? > > > > > > > > > Is there a way to pull out the last auto_increment id of a > > > insert statement in > > > MSSQL like the one that is avaliable for MySQL (namely > > > mysql_insert_id)? > > > > > > I'm inserting a record and would like to know the value of > > > the unique key so I > > > can pass that to another page right away. > > > > > > Thanks, > > > > > > > > > ________________________________________________ > > > Flint Doungchak > > > Web Applications Developer > > > Net Solutions LLC > > > 840 Lawrence Street > > > Eugene, OR 97401 > > > VOICE (541) 345-7087 FAX (541) 485-5519 > > > flint@netsolutionsllc.com > > > www.netsolutionsllc.com > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-general-help@lists.php.net > > > To contact the list administrators, e-mail: > > > php-list-admin@lists.php.net > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: > php-list-admin@lists.php.net