Rowversion or timstamp column
When a column is defined as rowversion or timestamp, please automatically exclude it from insert table column list.
6
votes
![](https://secure.gravatar.com/avatar/6d596b1a94b9f993a2b02bc91962cee9?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
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.