I think you will need to provide more information. I think you are talking about triggers and not stored procedures? Is this correct? On which table is the trigger and for which operation INSERT, UPDATE or DELETE?
Yes you are right. I am sorry for creating confusion.
Trigger is that which i want to create to update the history table automaticay.whenever any changes made in the employees table. So, it is going be an UPDATE operation in employees table and new isertion in History Table.
Is it better to have a date " w.e.f " column in employees table?or through trigger it can be attained?
if this column is there then user will have the option to change the date at any time.
otherwise there may be a chance that if adminstrator did not apply the changes on the same date then histroy table will not represent the true record. It will only record that date on which changes were made.