Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
khusiie
Yak Posting Veteran
78 Posts |
 Posted - 2008-01-28 : 09:35:39
|
| i have to put a trigger on SOP10100 table so that when a new NET order is created, and email will be sent to the email address associated with the customer ID (custnmbr). The email address for a given CUSTNMBR is in SY01200 in the INET1 field where SY001200.MASTER_ID = SOP10100.CUSTNMBR. –i have to use trigger to send email to customer. Relevant tables SOP10100 (SOPNUMBE and CUSTNMBR columns), and SY01200 (MASTER_ID and INET1 columns).can anybody help me to create trigger?Thanks a lot!!! |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-28 : 10:39:23
|
| worth reading :-http://www.4guysfromrolla.com/webtech/tips/t051706-1.shtml |
 |
|
|
khusiie
Yak Posting Veteran
78 Posts |
|
|
|
|
|
how to create trigger