If I do a simple INSERT statment into Table1, and print the @@Identity, of course I get an expected value. If I do an INSERT into View1 (Which is the view mentioned earlier), for Value1, Value2, I get multiple errors:
The column 'Value3' in table 'View1' cannot be null.
The column 'Value4' in table 'View1' cannot be null.
The column 'Value5' in table 'View1' cannot be null.
...
These values are nullable in the table definition, and they need to be nullable on an insert. I tried putting default values into the table definition, but that does not change the errors.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.