Tubes tied

I'm scared to have surgery I never had it before. Do they put you asleep? Does it hurt? What's the worst part of it? I have to have it done for medical reasons so please no rude comments.