mssql_insert_id() Does something like this exist???

friedmud

I am used to using mysql and in mysql I can use:

mysql_insert_id()

to get the id of the last inserted row. I am now working with mssql (don't ask me why - not my decision) and need to be able to do this same thing.

I know I could query the table sorting desc on the id and the top one would be the right one - but that's not quite feasible because this table could have ten's of thousands of entries and that operation would really slow it down.

Has anyone done this before????

Thanks for your help.

Derek

MrAlaska

I don't know the mssql functions and have never used the mysql function you refer to, but it seems you could include max(id) in the select part of your SQL statement to return the previous row's id, assuming that column is autoincrememted.

Lars_Berg

You should not use

select max(id) from t

That can really cause havoc in a multi user environment.

Use

select @@identity

immediately after the insert statement

friedmud

Thanks lars, I was actually looking at the max() function myself - and thought the smame thing (that it could cause havoc if multiple users hit it at the same time).

I will try what you said and post back later.

Derek

MrAlaska

Originally posted by Lars Berg
You should not use

select max(id) from t

That can really cause havoc in a multi user environment.

I would think you could write a pessimistic SQL update/insert statement to avoid havoc, but I am all for learning better ways of doing things (which is why I am here)

Use

select @@identity

immediately after the insert statement

What does that do?