Rowversion or timstamp column
When a column is defined as rowversion or timestamp, please automatically exclude it from insert table column list.
6
votes
Yuxin
shared this idea
This is fixed in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Jonathan
commented
I agree. This one gets me all the time. I'd categorize this as a bug because SQL doesn't allow you to specify a value for a timestamp column.
-
Phil Cole
commented
I agree, computed columns on insert were removed on version 4, timestamps were mentioned then too but nothing done, and pre-redgate versions defintely didn't include them on insert.