There is great satisfaction in reading the docs or searching the archive to find the
solution to your problem.. That being said I just don't have the time... I am under a
tight deadline for a project... I took a decent look at the archive but cant find
search words to isolate what I need....
Here is what I want...
a) A date and time record of when a new row in a table was INSERTED or UPDATED in a
table.
Here is how I think it should be done (pseudo-code) need the real code fore this. I am
certain its been written 100 times before - if someone would be so kind as to cut and
paste it for me ..
psuedo code
Trigger on Table Customer
Before Insert or Update
Set DateField = Today()
Set TimeField = Now()
Kind Regards,
---------------------------------
Post your free ad now! Yahoo! Canada Personals
