For jewelry, the issue is usually depth of field rather than simply lens choice. A macro lens is still a normal choice, but to get more of the piece sharp you’ll typically use one or more of these methods:

• Stop down the aperture to increase depth of field.
• Don’t stop down too far, because diffraction can soften the image; one answer suggested staying around f/9–f/10 rather than going much smaller.
• Use focus stacking for maximum front-to-back sharpness. This is a common solution for small products and requires taking multiple images focused at slightly different distances, then combining them.
• A tilt-shift lens can also help place more of the subject in focus, but these lenses are usually expensive.

So the most likely approach for a very sharp jewelry image is macro plus careful aperture choice, and often focus stacking if you want the whole piece crisp. A tele-macro lens by itself won’t automatically solve the depth-of-field problem.