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).
Colt M1911
Lieutenant George Hammond (Aaron Pearl) uses a M1911 as his sidearm in "1969" (Season 2, Episode 21).
Smith & Wesson Model 10
First seen in "1969" (Season 2, Episode 21) as the sidearm of Air Force security personnel.
Walther P99
The Walther P99 is used by rogue NID agents in "Touchstone" (Season 2, Episode 14).
Submachine Guns
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.
IMI Uzi
One of the east German guards in "The Gamekeeper" (Season 2, Episode 4) is seen firing a IMI Uzi at O'Neill and his team.
Rifles
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.
GAU-5/A and GAU-5A/A
The GAU-5/A and GAU-5A/A were the USAF contract versions of the XM177 and XM177E2 "CAR-15" short assault rifle. The USAF Security Forces still used them until recently, however, most of the non firing GAU-5A/As seen in the show were simply XM177E2 "Airsoft guns". The actual GAU-5A/A carbines look like the XM177E2 but don't have forward Assist buttons.
The GAU-5 variants that appeared on the show seem to be a mix of full-auto converted Colt AR-15 SP1s and Olympic Arms K3Bs, all with chopped barrels and fake GAU-5 flash hiders installed. The converted AR-15 SP1s have the "slab-side" receiver, while the K3Bs are recognizable by their 715-style receiver (forward assist, brass deflector, A1-style rear sight) and "Stowaway" pistol grips.
M16A1
Usually seen carried by the Cheyenne Mountain guards in stock footage. It could also be seen during the lockdown of the mountain in the episode "A Matter of Time" (Season 2, Episode 16).
Remington Model 700
A Remington 700 is used in the "The Gamekeeper" (Season 2, Episode 4). This one fitted with a bipod and suppressor.
SVD Dragunov
Used by a East German sniper in "The Gamekeeper" (Season 2, Episode 4).
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.
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 fake 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.
FN M249
Only seen twice, in "A Matter of Time" (Season 2, Episode 16), utilized during the lockdown of the mountain.
Heavy Weapons
M18A1 Claymore
Frequently used by the SG teams in order to lay traps. Usually used in conjunction with a remote detonator, much like the C4.
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. In a very memorable scene, Jack O'Neill (Richard Dean Anderson) drops two into the shield generator of a Goa'uld mothership in order to disable it during "The Serpent´s Lair" (Season 2, Episode 1).
Knives
Phrobis M9 bayonet
While not a firearm, an interesting fact is that the knife usually carried by Jack O'Neill (Richard Dean Anderson) is a Phrobis M9 bayonet with an OD Handle and sheath with an integrated pistol mag pouch. The most memorable scene featuring this weapon comes from the episode "Secrets" (Season 2, Episode 9): O'Neill uses it to disable Heru'ur´s Goa'uld hand-device.