General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
sql server - trigger/procedure need help
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_4
whenever 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.