They usually prescribe painkillers, afaik typically Vicodin. Your mileage may vary honestly. I've heard that some people experience a lot of pain. I didn't. I think I took one dose of the medication and then after the first day I was totally fine and didn't need them. After the surgery you will have holes in your gums for a little while and you have to take precautions not to let bits of food settle in them so they can heal properly. Honestly, keeping the holes clean was more annoying for me than the pain but again how much pain you're in can really vary. I stayed home for a full week to let the gums heal, but if not for the annoying hassle of dealing with that I was actually capable of working. In fact I think I spent the week mostly trying to teach myself game programming.
Oh also yeah they'll probably give you something to just knock you out completely. That means a needle but I remember it being really quick and not bad at all.