For this you can create the store procedure like this
CREATE PROCEDURE UpdateData
AS
BEGIN
SET NOCOUNT ON;
UPDATE USERS
SET [NAME] = 'ABC'
,[EMAIL] = 'abc@xyz.com'
,[PHONE] = '123'
WHERE [NAME] = 'PQR'
UPDATE Employee_Leaves
SET [EmpId] = 1
,[Name] = 'PQR'
,[LeaveStatus] = 3
WHERE [EmpId] = 3
END
GO
You just have to change your table names and column names