CREATE PROCEDURE dbo.insert @EmployeeName Nvarchar(50)
AS
insert into staff(EmployeeName,...)values(@EmployeeName,.....)
return scope_identity() /*如果staff表没有触发器,可以使用@@IDENTITY*/
GO
或者
CREATE PROCEDURE dbo.insert @EmployeeName Nvarchar(50),@ID int output
AS
insert into staff(EmployeeName,...)values(@EmployeeName,...)
set @ID = scope_identity() /*如果staff表没有触发器,可以使用@@IDENTITY*/
GO