XML inserts to a table with a time stamp
Posted on 2002-03-21
OK XML/SQL gurus, answer this...
I created a simple table :
and used OPENXML to insert test values using a simple XML string like
<Order A="33" B="21-Dec-2000" C="78.7"/>
No problem. I noticed that any fields not matched against attribute names don't get set. fair enough.
Then I added a timestamp field to the table. I got this error
Server: Msg 273, Level 16, State 1, Line 7
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.
I am not even trying to insert a value to time stamp. I tried the WITH clause and specific column names , but
that didn't work.
Any experts out there ?