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).
COP 357 Derringer
In the episode "Bad Guys" (Season 10, Episode 16) a COP 357 Derringer is used by a lowly security guard. It was never fired in the episode.
Glock 17
Used by rogue NID agents in "Memento Mori" (Season 10, Episode 8).
Jericho 941
In the episode 200 (Season 10, Episode 6), Mitchell imagined himself fighting zombies. If you forgot about this episode, yes zombies. When he was doing his last stand backing towards the activating gate, he took out a two tone Jericho 941 or the "Baby Eagle", as director Martin Wood refers to Mitchell's handgun correctly in the DVD commentary.
The Vektor CP1 can be seen during the episode "Company of Thieves" (Season 10, Episode 9) in the hands of Anateo (Rudolf Martin), Netan (Eric Steinberg) and another Lucian Alliance soldier.
Submachine Guns
Beretta PM12S
A number of Beretta PM12S submachine guns are seen used in the same episode "Bad Guys" (Season 10, Episode 16) as the Scorpion by security guards and the police of that planet. One was also taken by Teal'c so he can dual wield it.
FN P90 Personal Defence Weapon
Still the primary weapon of the SGC flagship team SG-1.
Heckler & Koch MP5A3
Most prominently featured in "Insiders" (Season 10, Episode 4) in the hands of Ba'al's clones.
Heckler & Koch MP5K
Members of The Trust in "Memento Mori" (Season 10, Episode 8) are seen using Heckler & Koch MP5K submachine guns.
H&K MP7
In the episode "200" (Season 10, Episode 6), Mitchell, in his own imagination, was seeing dual wielding MP7s with the gun's sights folded and with extended magazines fending off Zombies.
Kimel AP-9
The Kimel AP-9 can be seen in the episodes "Company of Thieves" (Season 10, Episode 9) and "Bounty" (Season 10, Episode 15) as one of the primary weapons of the Lucian Alliance foot soldiers.
Sa. Vz.61 Skorpion
Alien museum security personnel use Skorpions in "Bad Guys" (Season 10, Episode 16).
Shotguns
New Haven Model 600AT
In "Uninvited" (Season 10, Episode 5), the general and Mitchell were seen carrying New Haven Model 600AT pump action shotguns. General Landry (Beau Bridges) is carrying a New Haven Model 600AT 12ga Shotgun with a 28" ribbed barrel.
Winchester Model 120 Ranger
The shotgun that Mitchell (Ben Browder) is carrying in "Uninvited" (Season 10, Episode 5) is the Winchester Model 120 Ranger with a 28" barrel. It is chambered in 12ga. The Model 120 Ranger was a field version that was developed as a final 'variant' of the blued metal Model 1200. It was made between 1986-1989, well after the cessation of most of the Model 1200 production, but Winchester eventually ceased all production in favor of promoting their (cheaper to make) aluminum/alloy Model 1300.
Rifles
Heckler & Koch G36K
Two versions of this gun were seen throughout the running of SG1. The true "K" version with the scope and the "KE" version lacking the scope.
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.
Remington 7600
A hunter in "Uninvited" (Season 10, Episode 5) is seen with a Remington 7600 rifle.
Savage Mk.IIG
Darrell's rifle in "Bounty" (Season 10, Episode 15) is a Savage Mk.IIG or some variation thereof.
Winchester Model 62A
While Vala and Darrell are shooting tin cans in "Bounty" (Season 10, Episode 15), Vala (Claudia Black) uses a Winchester Model 62A pump action rifle.
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. 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.
Grenades
M67 fragmentation grenade
Utilized by the SG teams.
Flashbang
Used most prominently in "Insiders" (Season 10, Episode 4) to take out the guards of one of Ba´al´s clones. The specific make is - as of yet - unknown.