[thelist] SQL Server - TimeStamp

[David Mitchell]

A SQL Server timestamp does not actually hold a date/time value.. From 
the SQL Server BOL:

"The Transact-SQL timestamp data type is not the same as the timestamp 
data type defined in the SQL-92 standard. The SQL-92 timestamp data type 
is equivalent to the Transact-SQL datetime data type."

It's a binary number managed by SQL Server.

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
> 
> *****************************************************************************************
> This  electronic  mail  message  is  intended  solely  for  the  named  recipients  and  may contain
> confidential  and  proprietary  business information of eFunds Corporation and all its subsidiaries.
> If  you  are  not a named recipient, please notify the sender immediately.  You may not disclose the
> contents  to  any  other  person;  use  this  electronic  mail message or its contents for any other
> purpose; or further store or copy its contents in any medium
> *****************************************************************************************
> 
>