MSSql Insert Id

[Chucky]

Does anyone know how to get the previously/to be insert id for mssql?

In postgres, you can grab the id by getting it from the sequence. In mysql you can grab it by using the mysql_insert_id function. Is there anything close-by that can be used for mssql?

I'm going nuts. I don't want to query the database after insertion as if someone inserts something at the same time, chances are quite high that the insert id will be wrong. If possible, I would like to grab the ID before insertion, so that it will be dead on, like in Postgres.

Thanks, help, cry

--Chris

[Lars_Berg]

You can use the global variable @@identity or the function scope_identity.

Look them up in bol for more details.