This is what the rule states on Smogon's Rules page:
That's a bit vague though. What happens in battles on Showdown is that if one Pokemon is already asleep but not on the field, and you try to put another to sleep, the sleep move will fail and it'll mention something about Sleep Clause. If you had previously put a Pokemon to sleep but it is now dead, it'll let you put another Pokemon to sleep.