A nurse has been struck off the register of nurses and midwives after being found under the influence of alcohol and drugs while working.