Looking at needles, & piercings make me weak. Can I have general?

Unlikely. If your goal is to get piercings or tattoos, then these are done by non-medical practitioners who have no skills in general anesthesia and in fact cannot give local. You probably should re-think a decision to get these done if you cannot stand the discomfort.