http://flickr.com/photos/7939996@N07/
That guy has pretty sweet shots. He uses a 12-24 (I'm guessing, since most of his shots are at 12mm, f/4), and close to half-second exposures with flash on auto. My friend talked to a whosgoing.sg photographer and he uses a wide angle zoom too, so I wouldn't recommend a tele zoom (magnifies camera shake, and you WILL need to use a slow shutter speed in a club environment). The rull of thumb is get as close as possible with a wide angle, and at maximum aperture size.
Otherwise, I got a few usable shots just with a 18-70 on aperture prority, smallest aperture, or manual with flash on auto. I probably got them just because I took ~600 shots that night
Check out my flickr link in my sig