Staff weapon. Contained plasma blasts. Nasty way to go. One fun thing, they occasionally pull the power source out of those suckers, and they look like the old style Christmas lights... filled with tritium. I mean, in show it's "naquadah". But hey, if you can't get past the camp, you can't get past the camp.
Honestly, the entire first season is essentially outer limits with a budget. Season 2 is "All the planets they go to were a bad idea" and Season 3 introduces us to alternate alternate realities. (In addition to the stargate, they discover a device called a "quantum mirror" that lets you jump to alternate universes.) (The general bless'ed HATES the quantum mirror, and he's got a right to. In the first alternate reality, he's only a colonel, and in the second he is murdered horribly.)
They must have done something right, the original series made it 10 seasons, to be knocked off for the new hotness, Battlestar Galactica.
Which is doubly funny because SG-1 knocked the existing "Farscape" series out of rotation. So Farscape eventually got it's revenge.
Also, Ra died in the movie. Opening of SG-1 you're dealing with Apophis. Who looks like my Uncle's ex boyfriend.
Shame you don't like Jaffa, they get some primo moments throughout the series. Teal'c is of course, the best.
This joke comes from a not exactly funny episode, the ATF is standing off with a suicide cult.
different episode:
Sadly, I was not able to find a compilation of Bratac calling General Hammond, who commands the stargate base "Hammond of Texas". It's a sign of true respect, but always made me chuckle.