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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Insert problem

Author  Topic 

shubhada
Posting Yak Master

117 Posts

Posted - 2006-08-14 : 02:36:09
I have one table test with column timestamp.
create table test
(
timestamp timestamp null
)
I am trying to insert the value in this column.
insert into test
values (0x000000000008E189)
but I got the following error.

Server: Msg 273, Level 16, State 1, Line 1
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.

please tell me how to resolve this problem

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-08-14 : 02:48:16
duplicate post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70437

Chirag
Go to Top of Page
   

- Advertisement -