IDENT_CURRENT.返回为指定表或视图生成的最后一个标识值.最后生成的标识值可以用于任何会话和任何范围.

IDENT_CURRENT. Returns the last identity value generated for a specified table or view. The last identity value generated can be for any session and any scope.

SCOPE_IDENTITY.返回插入到同一范围内的标识列中的最后一个标识值.范围是一个模块:存储过程、触发器、函数或批处理.

SCOPE_IDENTITY. Returns the last identity value inserted into an identity column in the same scope. A scope is a module: a stored procedure, trigger, function, or batch.

输出.从受 INSERT、UPDATE、DELETE 或 MERGE 语句影响的每一行返回信息或表达式.[...] OUTPUT 子句可能有助于在 INSERT 或 UPDATE 操作之后检索标识或计算列的值.

OUTPUT. Returns information from, or expressions based on, each row affected by an INSERT, UPDATE, DELETE, or MERGE statement. [...] The OUTPUT clause may be useful to retrieve the value of identity or computed columns after an INSERT or UPDATE operation.