When you have a numeric, the first number (p) is the total number of digits that can be stored. The second number (s) is how many of those digits are on the right of the decimal point. Numeric(5,5) means store 5 digits total, all 5 on the right of the decimal point.

DECLARE @test-2 Numeric(5,5)

set @test-2 = 0.12345

select @test-2