Help how to get the last insert ID in sql.

[ryoka012]

Hi,
Can anyone help with how to call the last value of a insert ID in sql.
using a php..
Note:
is use mssql not mysql.
Thanks.

[transio]

$sql = "insert into... values(...); select @@identity;";