在发送表ID中的两个表中插入数据时，不插入，但在我插入数据时，第二个表ID应从第一个表中插入

Create Procedure Sp_instAdminmaster] 
(@Name varchar(20),@FatherName varchar(20),@Email_Id varchar(20),@Address nvarchar(100),@City varchar(20),@State varchar(20),@Qualification varchar(30),@contactNo varchar(10),@Date date,
    @Remarks varchar(150),@Type varchar(20),@Fee money,@ClassName nvarchar(20),@Yearly money,@Halfyearly1 money,
    @Halfyearly2 money,@Quaterly1 money,@Quaterly2 money,@Quaterly3 money,@Quaterly4 money,@January money,
    @February money,@March money,@April money,@May money,@June money,@July money,
    @August money,@September money,@October money,@November money,@December money)
        AS
BEGIN
Insert into AdmissionMaster(Name,FatherName,Email_Id,Address,City,State,Qualification,contactNo,Date,Remarks,Type,Fee,ClassName)
values (@Name,@FatherName,@Email_Id,@Address,@City,@State,@Qualification,@contactNo,
    @Date,@Remarks,@Type,@Fee,@ClassName);
declare @Id int 
Select @Id as Id  from  AdmissionMaster 

insert into tblAdmissionDetails(Id,Yearly,Halfyearly1,Halfyearly2,Quaterly1,Quaterly2,Quaterly3,Quaterly4,
    January,February,March,April,May,June,July,August,September,October,November,December)
    values(@Id,@yearly,@Halfyearly1,@Halfyearly2,@Quaterly1,@Quaterly2,@Quaterly3,@Quaterly4,@January,@February,@March,
    @April,@May,@June,@July,@August,@September,@October,@November,@December)
END