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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 timestamp in a table

Author  Topic 

akpaga
Constraint Violating Yak Guru

331 Posts

Posted - 2008-06-11 : 13:30:46
i want to use timestamp for a coloumn in my table so that whenever a new record is inserted the the timestamp column is populated with the date and time.
But when i do that nothing is showing up except the words <binary>
in that coloumn.

what is the problem.
thanks in advance

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-11 : 13:37:03
Set the column's data type to datetime and add a default constraint of GETDATE().

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

akpaga
Constraint Violating Yak Guru

331 Posts

Posted - 2008-06-12 : 12:00:53
thanks for the response .
this thread rocks
Go to Top of Page
   

- Advertisement -