In a nutshell, self-limiting beliefs can have these effects on you:

1) lead to procrastination and laziness,

2) destroy and dampen your hopes and aspirations,

3) bring down your morale

4) make you lose complete focus of you goals, dreams and aspiration

5) deviate you from your intended successful path and goal.

And tons of other negative effects