插入一条记录同时返回该记录在表中的ID值

create Procedure Test_Insert
@ID INT,
@Title NVARCHAR(100),
AS
declare @TestID int
INSERT INTO Test
(
  ID,
  Title,
)
VALUES
(
  @ID,
  @Title,
)
set @TestID=@@identity
return @TestID

支持！好 ！好！