SELECT @@IDENTITY
- From: chucky <chucky@xxxxxxxxxxxxxxx>
- Date: Wed, 24 Jan 2007 21:59:31 -0500
I can't seem to figure out how to add SELECT @@IDENTITY to my SQL INSERT statement in my Perl cgi script. I am testing this with an MS Access db, but my production db will be MSSQL 2000 (don't know if there is a difference between the two in how they handle the @@IDENTITY.)
The web server is IIS6 and perl v5.006001.
I am currently using Win32::ODBC calls, but I am open to whatever works.
.
- Prev by Date: Re: DBD::Oracle: Row cache fetch ahead on cursor returned from PL/SQL stored proc?
- Next by Date: Re: Connect to a remote MS SQL database
- Previous by thread: Connect to a remote MS SQL database
- Next by thread: DBI Module
- Index(es):
