CREATE PROCEDURE UpdateUserName @OldName varchar(255), @NewName varchar(255) AS UPDATE Users SET UserName = @NewName, LikeCount = 0 WHERE UserName = @OldName GO