什么是通过SQL更新单个记录并获取更新记录的id的最佳方法？ （爪哇/ MSSQL）

I know I can update a single record like this - but then how to I get access to the id of the record that was updated? (I'm using MSSQL so I can't use Oracles RowId)I know I can update a single record like this -