Well, not a conventional drinking song, perhaps; but the (in)sensibility is much the same. And I can imagine this being fun to sing while drunk... or, um, high.
Here's the original video for (the full version of) Afroman's Because I Got High, from when it first appeared as the end credit music in Kevin Smith's Jay and Silent Bob Strike Back.
But here's something even better I just found on YouTube: the song illustrated with a compilation of great clips from The Simpsons. (This will almost certainly get pulled quite soon, so enjoy it while it you can.)