如下图所示。
SCOPE_IDENTITY()在这种情况下，您可以用来获取最后一个自动生成的ID以及此存储过程的作用域：
create procedure NameOfYourProcedureHereasbeginSET NOCOUNT ON;SET XACT_ABORT ON; insert into custlogin(custusename, custpassword) values ('','') -- put values here (from parameters?) insert into custinfo(custid, custfirstname, custlastname, custaddress) values (SCOPE_IDENTITY(), '', '', '') -- put other values here (from parameters?)SET NOCOUNT OFF;SET XACT_ABORT OFF;end
