SQL Server table and view show different values
When a view is created it is bound to the metadata it needs in order to execute.  

Note:  https://msdn.microsoft.com/en-us/library/ms187821.aspx

That says that sp_refreshview: "Updates the metadata for the specified non-schema-bound view. Persistent metadata for a view can become outdated because of changes to the underlying objects upon which the view depends."

The outdated metadata binding causes the surprising "wrong" results.  Using schema-bound views is one way of avoiding the problem.

Read the link that Aaron Bertrand posted: 


https://sqlblog.org/2009/10/10/bad-habits-to-kick-using-select-omitting-the-column-list