Mssql Last inserted id

[eluser]shankar ganesh[/eluser]
How to get last_inserted_id in mssql using php?

[eluser]Alexandru M.[/eluser]
In mysql and postgresql I use $this->db->insert_id() , should work with mssql too.

[eluser]WanWizard[/eluser]
No, it doesn't. MSSQL doesn't support a last insert id.

There are some tricks possible, they've been posted here before, use the search...