Update multiple columns and rows at same time in SQL Server

Hi RichardSa,

Refer below query.

CREATE TABLE Users2
(
	Id INT
	,email VARCHAR(50)
	,Name VARCHAR(50)
	,CreatedBY VARCHAR(60)
	,LastLogin VARCHAR(70)
)

INSERT INTO Users2 VALUES('1', 'richard@gmail.com', 'RichardSa', 'richard@gmail.com', '14-Feb-23 8:05AM')
INSERT INTO Users2 VALUES('2', 'sammy@gmail.com', 'RichardSa', 'richard@gmail.com', '17-Feb-23 1:35PM')
INSERT INTO Users2 VALUES('3', 'manny@gmail.com', 'RichardSa', 'richard@gmail.com', '20-Feb-23 6:48PM')
INSERT INTO Users2 VALUES('4', 'mike12@gmail.com', 'Mikey', 'mike12@gmail.com', '20-Feb-23 9:14PM')
INSERT INTO Users2 VALUES('5', 'okon@yahoo.com', 'Mikey', 'mike12@gmail.com', '20-Feb-23 11:58PM')


--EXEC Update_ChildUserData 'abc@gmail.com','abc','richard@gmail.com','RichardSa'
ALTER PROCEDURE Update_ChildUserData
	@Email VARCHAR(50),
	@Name VARCHAR(50),
	@OldEmail VARCHAR(50),
	@OldName VARCHAR(50)

AS
BEGIN
	UPDATE users2 
	SET CreatedBY = @Email
	   ,Name=@Name
    WHERE CreatedBY=@OldEmail and Name=@OldName

	UPDATE users2 
	SET email = @Email
	   ,Name=@Name
    WHERE email=@OldEmail or Name=@OldName
END

Screenshot

I was thinking that in an instance a user decides to change email, maybe as a result of the older email not working again.

But I did not think of the user email as being a unique value the user uses to login. 

However I have situations where users change emails as a result of the former email not being functional anymore.

I was recently browsing a website and when I went to settings I saw where I can update my account like name, email and password. Even though the email is the username used to login.

After thinking it through, I just discovered that instead of using email to link principal user to child user, I can use the Id of the principal user as the basis which child user is linked to the principal user. That way,  I do not have to change the email in principal email in CreatedBy column.

Thank you for giving me that direction to have a rethink