สอบถามเรื่อง mysql_insert_id หน่อยครับ ? จาก mysql_insert_id ใน MySqlถ้าผมจะใช้ฟังชั่นนี้ใน MS-Sql ต้องเขียนยังไงครับ ?

$con = mysql_connect("localhost", "peter", "abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

$db_selected = mysql_select_db("test_db",$con);

$sql = "INSERT INTO person VALUES ('Børge','Refsnes','Sandnes','17')";
$result = mysql_query($sql,$con);
echo "ID of last inserted record is: " . mysql_insert_id();
mysql_close($con);

$strSql = "
INSERT INTO Member
(UserId,FirstName,LastName,Email,AddDate) VALUES
('$sUserId','$FirstName','$LastName','$Email','$AddDate')
";
mssql_query($strSql);
 
$strSql = "SELECT @@IDENTITY AS LastId";
$objResult = mssql_query($strSql);
if (!$objResult) { echo "$strSql"; exit; }
while($row = mssql_fetch_array($objResult)) {
$LastId	=	$row[LastId];
}
mssql_free_result($objResult);