General discussion
-
Topic
-
sql server – trigger/procedure need help
LockedHi all,
I am a newbie of sql server programming. can anyone help me?
1. I am having a table called sonic. whenever any
changes insert/delete/update done in the table i
need to export this table in a mdb file and mail
this mdb to several locations.
plz guide how can this be possible. by using
trigger or stored procedure. How to export the table in mdb.2.there are two tables one is cns and second is route.in cns i am having fields
from_station,to_station,enroute_1,enroute_2,enroute_3,enroute_4
In route i am having fields
from_station,to_station,enroute_1,enroute_2,enroute_3,enroute_4whenever a new record inserts enroute fields value not given these value should be update from route in cns after inserting a new record in CNS.
for that i need to select enroute fields value on the condition from_station,to_station and update it in the cns table at the time of insertion.
Plz guide if anyone can.