CREATE PROCEDURE addrecord @s1 varchar(50),@i1 int ,@id int output AS insert into t (str,number) values(@s1,@i1) select @id = max(id) from t GO
CREATE PROCEDURE addrecord @s1 varchar(50),@i1 int ,@id int output AS insert into t (str,number) values(@s1,@i1) set @id = @@identity --SQL Server全局变量,返回最后一次插入的标识值 GO
insert into t (str,number) values(@s1,@i1)
select @id = max(id) from t
GO
insert into t (str,number) values(@s1,@i1)
set @id = @@identity --SQL Server全局变量,返回最后一次插入的标识值
GO