update time whenver update existing column

Hi Dharma,

If you wish to se only updated date then you can create trigger.

If you are using store procedure then you can set yout modified coulmn,

UPDATE Employee
SET ModifiedDate=GetDate()    
WHERE Id= 'EmployeeId'  
 If you are using Entity Framework then,

using (EFContext db = new EFContext())  
{       
    var emp = db.Employee.Where(d => d.Name == "Test").First();  
    emp.ModifiedDate = DateTime.UtcNow;  
    db.SaveChanges();  
}  

or you can create trigger,

https://stackoverflow.com/questions/21493178/need-a-datetime-column-in-sql-server-that-automatically-updates-when-the-record