Changing A Stored Procedure To Inline Sql

Hi i have the following stored procedure, i am trying to convert it to inline sql, however i got stuck,  because how would i output a value e.g "@Access_Right_ID",  this is the stored procedure below


CREATE PROCEDURE dhoc_AccessRight_Insert
 @AccessLevel char(50),
 @Access_Right_ID int OUT,

 @Tstamp timestamp out


 AS
SELECT * FROM tblAccess_Right

WHERE
AccessLevel = @AccessLevel
 
IF @@ROWCOUNT <>0
   BEGIN
         RAISERROR('This record is already in the database',16,1)
         RETURN 14
    END

ELSE
   BEGIN
 SET NOCOUNT OFF;
             INSERT INTO tblAccess_Right (   AccessLevel ) VALUES (@AccessLevel);
            SET @Access_Right_ID = @@Identity
            SET @Tstamp = (SELECT Tstamp FROM tblAccess_Right WHERE Access_Right_ID=@Access_Right_ID)

      --Make sure this has saved, if not return 10 as this is unexpected error
     IF @@rowcount = 0
 BEGIN
                    RAISERROR('This record has not been inserted at this time, it might have been inserted by another user, please try again',16,1)
        RETURN 10
 END
     ELSE
          BEGIN
 
 IF @@error <>0
 BEGIN
  
  RETURN @@error
            END
     END
END

GO