I've used the Nokian W106, Nokian Extreme 294, and Schwalbe Winter Marathon.
The W106s were 26" on a mountain bike. I rode them through last winter, and they were excellent. There was a day in particular that I remember where the cobblestone street near the house froze over, and I was still able to ride it despite that fact that 4X4s could not drive the hill. They were also reasonable during the majority of the time when the roads were dry, though you have to expect them to be noisy and much slower than slicks. They are available in 700X35 (and 700X45, if you have that much clearance).
The Extremes are off-road specific mountain bike tires, and will not fit most road bikes (I think the smallest they come is 700X52).
The Winter Marathons are on my bike now, and I think they are OK. I got the 700X42 size, but they also come in a 700X35. I don't like them as much as the W106, but that could be because they are on a different bike that may just not be as cut out for wintery conditions (I am currently riding a Kona Ute instead of a Fisher Supercaliber. It's a tough comparison.) I find them a little more squirrelly in the snow, though most of your riding will be on dry streets, and the point of the studs is to save you from the occasional patch of ice.
Nokian also makes the A106, which is more road-friendly, with less aggressive tread but still some studs. They come in sizes as small as 700X32, which may be better for clearance. I have never ridden them.