Some antidepressant drugs, such as trazodone (Desyrel), are very good at treating sleeplessness and anxiety. Benzodiazepines: These older sleeping pills — emazepam (Restoril), triazolam (Halcion), and others — may be useful when you want an insomnia medication that stays in the system longer.