In my database every table have a column EntryDate datetime default getdate() . Now my question is: how can i update this column EntryDate when any field in my table is updated. I dont want to use trigger. Thanks Eric Lall
create table Mytable name varchar(30), age int, address char(50), EntryDate datetime default getdate();
If all access to write to your tables is through stored procedures, you can simply make sure that all your procedures has this built in. If access is through a known set of code, you can make sure it's built into that known set of code. But if it's completely ad hoc, the only way to make something like this work is through triggers.