What happens when the speed sensor is bad?

What happens when the speed sensor is bad?
Speedometer either doesnt work, is erratic or works when it wants to.
This may also cause erratic shifting in the transmission or transmission to stay in 2nd gear when in drive.