In one statement: No, as far as my knowledge goes on.
In one transaction: Yes
BEGIN TRANSACTION
DECLARE @EmpID int;
INSERT INTO emp (Column1 ...) VALUES (....);
SELECT @EmpID = scope_identity();
INSERT INTO sal VALUES (@Sal, @EmpID);
COMMIT
Thank you,
Vamsi