what to expect with dental sedation

If I Use a Sedation Dentist Do I Sleep there Until it Wears Off?