The song you are looking for is called "Mary's a Grand Old Name" by George M. Cohan and can be found at The Lester S. Levy Collection of Sheet Music. Do a bibliographic search and look for the phrase "and it was Mary".