Can you produce a sample using either the Northwind or Pubs database that reproduces the problem that you're seeing?
Is this just an issue with the query windows in SEM? If you issue INSERTs from the Query Analyzer, do you get the correct values when doing a SELECT?
-Mike