Viewing 2 posts - 31 through 32 (of 32 total)
better way is to define a default and bind to the column as follows.
It is better to avoid triggers to improve the performance.
create default today as getdate()
sp_bindefault today ,'
February 13, 2007 at 3:04 am
#689393
Another most frequently used option
is to have a modified_date column in all tables with getdate() as the default option
so as to find when the table was modified at...
February 9, 2007 at 5:41 am
#688782