Timestamp columns

Jul 14, 2009 at 8:16 AM
Edited Jul 14, 2009 at 8:19 AM

Some tables like storyVote have a column named Timestamp

Timestamp is keyword in SQL Server and should not not used as column name

Jul 14, 2009 at 9:34 AM

Yes it is. In KiGG the column is used as Datetime column. There is no harm to use some database keywords as column names as long as you write your queries properly.

This column is working as time stamp for modification of a record. But I guess Rashid wanted to use it as real datetime column and not as SQL SERVER timestamp column which I think is translated to binary in .Net