在SQL Server中有效地存储数值，这些数值的大小可以是多种多样的?

I have a column in a SQL server database that stores numeric values. The issue is that sometimes the number is Billions, sometimes it's 1.355 E -16. I would set the numeric to be something huge like numeric(35,20) but I assumed that will make them all take up that much space in the database, and that seems like such a waste. Is there a way to do this efficiently, like how we use varchar when sometimes having short strings and other times having long strings?I have a column in a SQL server database that s