The most common sidearm seen in used by the SG teams (although in real life, the M9 is the military designation for the Beretta, the prop weapons used in the show are most likely the civilian Beretta 92FS).
(Mock-up) Beretta M93R
Machine pistols with the appearance of Beretta 93Rs are seen in a number of episodes being used by US Secret Service agents, and the Trust agent Hoskins. If you look closely, you can see that they have the slide-mounted safety/de-cocker switch, whereas the 93R has it mounted on the frame. That means they're actually Beretta 92FS dressed up to resemble M93Rs (with fake forward grips and flash hiders) and probably converted to auto with drop-in units; identical guns have also appeared in Harsh Realm and I, Robot (which were both done by the same armourers who worked on this show).
Submachine Guns
FN P90 Personal Defence Weapon
Primary weapon of the SGC flagship team SG-1.
Heckler & Koch MP5A3
The Heckler & Koch MP5A3, almost exclusively equipped with the Surefire dedicated forend weaponlight, is the primary weapon used by all SG teams for the first few seasons. Then when the main cast and some supporting and extras switched to the P90, the MP5 became less common. Also seen in use by the Free Jaffa Nation later in the series. MP5 also makes a small comeback when we see them again in the hands of a special assault unit raiding a Trust compound. Throughout the series it is generally the case that for non firing scenes the actors carry airsoft replica MP5s with a Navy trigger group, whereas for firing scenes their weapons switch to real firearms with SEF trigger groups.
Shotguns
Ithaca 37
In the Episode "Evolution, Part 2" (Season 7, Episode 12), a Honduran rebel uses a chopped down Ithaca Model 37 12 gauge shotgun.
Rifles
Barrett M82
Seen being used by SG-3 in "Fallen" (Season 7, Episode 1). What's interesting to note is that while most of the other SG teams use submachine guns, SG-3 is armed with an M82, M16, M16 with M203, and an M60. They are a USMC section tasked with SAR, retrieval and Tactical Support ops. They pretty much come out to play when extra firepower is needed or another team got into a situation that they can't handle.
"Carter Special" Micro Carbine
This appears to be a customized Olympic Arms K23B with a short 7" barrel, aftermarket quadruple-rail SOPMOD accessory forend, and a modified thumb-hole stock taken from a Sterling AR-180 rifle. It is used with an ELCAN sight and a Beta drum mag with a mounted vertical foregrip and a side-mounted flashlight on the accessory rail. The first appearance is in "Avenger 2.0" (Season 7, Episode 9). It gets its name from Major Samantha Carter, the only character who carries it. We later also see it in "Heroes, Part 2" (Episode 18 of Season 7). According to the DVD commentary, it was intentionally made because blanks for the P90s were becoming increasingly expensive.
Diemaco C7/Olympic K4B
Seen used by Marines, and the security of Stargate Command. These are all Olympic Arms K4B rifles (same receiver style as the Colt Model 715/Diemaco C7), standing in for the M16A2.
Heckler & Koch G3SG/1
Used in the episode "Orpheus" (Season 7, Episode 4) by O'Neill. G3SG/1 is the real name of the rifle, and a coincidence to the name of the team that used it on occasion. It's also seen numerous times in the episode "Enemy Mine" (Season 7, Episode 7), in the hands of a Marine.
M16A1
Usually seen carried by the Cheyenne Mountain guards in stock footage.
M4A1
One of the primary weapons utilized by the Stargate teams. During later seasons they are rarely seen without any attachments, mostly being equipped with flashlights, Cobray flare launchers and laser aiming modules. A small side note for the interested reader: The lower handguard on the M4 has to be removed in order to accommodate underbarrel grenade launchers like the M203 or, in this case, the Cobray 37mm Launcher.
Zastava M70
The weapons used by the Honduran Rebels in "Evolution" Part 1 and 2 (Season 7, Episode 11 & 12) are versions of the Zastava M70. Government soldiers and zealots in "Icon" (Season 8, Episode 5) can also be seen wielding them.
Machine Guns
Browning M2
These two guns were set up in the gate room but were never used in the 10 years the show ran for. The M2 was also used at the Alpha site in "Allegiance" (Season 6, Episode 9), but was - once again - not fired. The weapon was then seen in "Bad Guys" (Season 10, Episode 16), mounted on an APC used by the alien security forces. The only instance were the weapon saw actual combat was in "Forever in a Day" (Season 3, Episode 10), were it was mounted on a F.R.E.D. during the onslaught of Heru'ur´s Jaffa.
Daewoo K3 (mocked up as M249)
Contrary to popular belief, there are no real FN Minimi or M249 light machine guns used in Stargate: SG1 or its sister show, Stargate: Atlantis. The light machine guns used by the SG teams are actually Korean-made Daewoo K3s that have been fitted with M249 Paratrooper-style stocks and shortened barrels. Some of the K3s seen on the show also have RIS rails and vertical grips similar to those seen on the Mk 46 Mod 0.
M60 Series GPMG
Seen used by Marines in a support role in several episodes and the movie Stargate: The Ark Of Truth. Some marines are carrying the M60E3 version.
Heavy Weapons
Cobray CM203 Flare Launcher
Seen attached to M4s and M16s. Prop wise, these were all Cobray 37mm flare launchers meant to mimic the appearance of an M203. What tips them off is the absence of a second trigger, the shape of the trigger guard, the lack of a step up in the receiver, and the cocking lever on the SIDE of the receiver.
M203 Grenade Launcher
What appears to be a genuine M203 grenade launcher appears in "Evolution, Part 2" (Season 7, Episode 12) mounted on an M4A1.
Mortar Unknown type
Seen in "Orpheus" (Season 7, Episode 4). SG-3 used these to lay mortar support during the assault on the Jaffa labour camp.
M136 AT-4
Most commonly 'misused' as a surface-to-air missile to shoot down Goa'uld Death Gliders, however, the AT-4 is an 84mm Anti Tank Weapon. It has also been used just as a weapon to make big explosions.
Milkor MGL
This launcher, or a version thereof, was used by Teal'c in the episode "Death Knell" (Season 7, Episode 16) when hunting an Anubis Super Soldier.