automatically update record in database

[marlina]

hi,
here i try to find-out function that can automatically update records in database (staff development system). got 3 tables would been changed at one time. the tables are: tbl_staff, tbl_transit(temporary table) and tbl_htrystaff(history table). so, how to automatically transfer/update the data that have an Effective_date (today) from table tbl_transit into table tbl_staff while the effected data at table tbl_staff will be transfer into table tbl_htrystaff.

 

[TheBestOfMe]

I think you can to this with triggers.

 

[marlina]

i don't know how to write that trigger. could you give me some sample trigger for it.

 

[tlbroadbent]

Marlina,

Check out the SQL Server documenation. SQL Books Online (BOL) has great examples of triggers. If you are not familiar with SQL BOL see faq183-689 - "What are SQL Books Online & Where Can I Find Them?"
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.