[thelist] SQL Server - TimeStamp
Clayton Smith
clayton at geni-us.com
Tue Jun 1 11:06:55 CDT 2004
I'm going to make a guess.. and this is just a guess..
if a column is a timestamp column then that row is given a timestamp
everytime a new row is inserted.
so, you would probably setup a different field to fulfill your need.
the timestamp is probably also running a function which maybe you can
disable somehow ?
-c
Seshadri.Varadhan at in.efunds.com wrote:
>Hi,
>I have SQL Server table with TimeStamp column. I canno insert values into this field. When I try to
>Insert values into this field it says the followin 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."
>
>Kindly let me know how to insert values into this field.
>
>Thanks in Advance,
>Seshadri
>
>
>
More information about the thelist
mailing list