Moffat, who also oversees Doctor Who, was honoured with the special award for outstanding writing.
Accepting the award, he told the London ceremony: “Write what you love. I’ve never loved anything as much as Doctor Who and Sherlock.”
Doctor Who spin-off The Sarah Jane Adventures, written by Phil Ford, took the prize for best children’s TV script for its episode The Curse of Clyde Langer.