Php + mssql (~)

Php + mssql getting the last inserted id value (online, etc ~) I remember that mysql has a mysql_insert_id () function to obtain the last inserted id, for example, $ newID = mysql_insert_id (); what about the mssql database? Is there such a function? How can I output the last inserted id php + mssql to obtain the last inserted id value (online, etc ~)
I remember that mysql has a mysql_insert_id () function to obtain the last inserted id, for example, $ newID = mysql_insert_id (); what about the mssql database? Is there such a function? How can I output the last inserted id?


------ Solution --------------------
At least not found in the manual,
Query once.

------ Solution --------------------
Query select @ IDENTITY

Mssql has its own system variables
------ Solution --------------------
Discussion
Query select @ IDENTITY

Mssql has its own system variables

------ Solution --------------------
Discussion
No, do you have to write it like this? Is there any other way? I did not find such a function. The combination of mssql and php made me very uncomfortable. what I am doing now is a master-slave table structure, you need to store the id of the master table to insert data from the table.

------ Solution --------------------
Discussion
It is not difficult. if the primary key is a student ID, rather than an incremental identifier, what should I do?

------ Solution --------------------
Select @ IDENTITY can be used if INSERT exists.

I have never seen any problems upstairs.

Is there a problem with concurrency?
Where should I write a stored procedure?
------ Solution --------------------
In addition to the stored procedure, the simplest and most direct method is to construct a query to ensure the uniqueness of the query conditions.
------ Solution --------------------
Select once after insertion... find the id ..