Getting last inserted Id from SQL Server

[reagent]

I'm using php 4.0.5 on Windows 2k and SQL Server 7. To connect to the database, I am using the odbc_* functions.

Is there any way that I can get back the autonumber value that was last inserted, like the mysql_insert_id() function?

thanks.
p.

[reagent]

p

[neuromancer]

No, I would recomend using a stored procedure to do your inserts as follows

CREATE PROCEDURE n (
@parameter INT
)
AS
INSERT INTO x (n,...) VALUES (@parameter,...)
SELECT @@IDENTITY AS xID

[neuromancer]

Look at your TSQL help on GLOBAL (@@GLOBAL) variables

[daath]

$sql = "SELECT @@IDENTITY AS Insert_ID";

[neuromancer]

Why would you use raw SQL over a STP ? Here is a better example

CREATE PROCEDURE n (
@parameter INT
)
AS
BEGIN TRANSACTION
INSERT INTO x (n,...) VALUES (@parameter,...)
IF @@ <> 0
BEGIN
SELECT -1 AS ErrNo, 'Failed to insert into x' AS Message
ROLLBACK TRANSACTION
RETURN -1
END
ELSE
BEGIN
SELECT 0 AS ErrNo, 'Success' AS Message, @@IDENTITY AS xID
COMMIT TRANSACTION
RETURN @@IDENTITY
END