It's not nearly as good as SG-1 or Atlantis. Also you won't catch half of the references if you don't have the aforementioned background.
I'd definitely advise you to watch the original movie "Stargate" first then watch SG-1 ... there are 10 seasons, but the first 6 - 8 are the most important - technology wise etc.
