Thisis my first shot at working with creating own sql database

I want to create a column of interest rates from .125 % to 21 % incremented by .125%

Is there a way to "auto" create the column so i dont have to type in each rate

And can you store percentages in a sql database? or should it be a decimal, then format before display

Thanks for any feedback and help