SQL Server Performance Forum – Threads Archive

DML Trigger

I am using AFTER INSERT trigger to send an email to the user using database mail. Everthing is OK. The question is that How can I include the data of that particular inserted row to be included in the email?

---

inserted data will be in a table called inserted.
ex.
if you want to send customer name
select @customername = customername from instered
then use @customername to fomulate your mail body —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

Lookup at SQL 2005 books online for such code example. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

---

]]>