Stored Procedures||How to call a procedure within another procedure?

1. Create Proc GetEmployeeData
@empid int
AS
BEGIN
select id,name,gender,sal from emp where id=@empid
END

2. Create Proc GetEmpInfo
@empid int
AS
BEGIN
INSERT INTO emp_audit(AuditMessage,RecordedOn) VALUES('Getting details for EmpId: '+Cast(@empid AS Varchar),
Getdate())

EXEC GetEmployeeData @empid
END

EXEC GetEmpInfo 3

Видео Stored Procedures||How to call a procedure within another procedure? канала SQLtoSSIStoPowerBI