Which pills can give sleep immediately?

None,this can only be done by gas or needle injection.

If not, there are always the anesthetic pills which dont give sleep immediately but still knock you out after awhile. However, I do not think doctors give them out as they are meant for surgery