SQL Server extract only the number after the decimal point

Dec 17, 2021 · 1 min read · One of my blog readers asked me "Is there a way to extract only the number after the decimal point?". For example, in decimal number 45.90, 45 is the precision and 90 is the scale value. There are several methods to get this done Let us create this d...