IDENT_CURRENT 返回为任何会话和任何作用域中的特定表最后生成的标识值。
示例代码:
====================
ALTER PROCEDURE [dbo].[pr_test]
@txt as varchar(100),
@last as int output
AS
BEGIN
declare @sql varchar(100)
INSERT INTO [tb_txt] (txt) VALUES (@txt)
set @last = CAST(IDENT_CURRENT('tb_txt') AS int)
END
====================
@@IDENTITY 返回为当前会话的所有作用域中的任何表最后生成的标识值。
SCOPE_IDENTITY 返回为当前会话和当前作用域中的任何表最后生成的标识值。
====================
ALTER PROCEDURE [dbo].[pr_test]
@txt as varchar(100),
@last as int output
AS
BEGIN
declare @sql varchar(100)
INSERT INTO [tb_txt] (txt) VALUES (@txt)
set @last = CAST(SCOPE_IDENTITY() AS int)
END
====================