Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hwoarang
Starting Member
14 Posts |
 Posted - 2009-04-03 : 06:11:03
|
| Can anyone help to explain what is this mean "Cannot insert a non-null value into a timestamp column. Use INSERT with a column list or with a default of NULL for the timestamp column."Thanks . |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-04-03 : 06:14:08
|
| You have a timestamp column you are trying to insert into. Where you are doing an insert into <tablename>, you need to either provide a column list on the select you are using to insert into or change the table to accept NULLs on this column. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-03 : 12:48:54
|
| The reason is you cant insert an explicit value for timestamp column. The value is autopopulated by system for each dml operation like insert/update. so what you need is to exclude that column in select/insert list or pass a default value of NULL for timestamp. |
|
|
|
hwoarang
Starting Member
14 Posts |
Posted - 2009-04-03 : 20:57:05
|
| oic, many thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-07 : 11:04:04
|
| welcome |
|
|
|
|
|
|
Cannot insert a non-null value into a timestamp co