Time stamps | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Time stamps

Hello, I am new to sql and I need some assistance. I am trying to time stamp new entries into my database some I can calculate performance. My problem is the simple fact that i do not know how to go about creating a time stamp. I have read many things which all suggest different things. Is there a standard way that I can use to track new entries with time? If anyone can help that would be great! Joe
The simplest way is, create a column with datetime data type and assign a default of getdate() to it. For example: Alter table xyz add tmstmp datetime DEFAULT getdate()