retreive inserted id in mssql

[Anon]

hi,
i tried using SELECT @@ IDENTITY for retreiving the latest inserted id but it is not working.is there any other method to retreive the latest inserted id in mssql?

kindly help me out

archana

[mrjam]

mysql_insert_id -- Get the id generated from the previous INSERT operation

?