What are singleton and single-run procedures?
What does it mean to run a procedure as SINGLETON or SINGLE-RUN? How are these two modes alike, and how do they differ? How are singleton and single-run procedures like persistent procedures, and how are they different?