Very Computer

Tricky: I have a table on a SQL Server with no identity field.

ON INSERT on a table, I need an email to be sent to somebody advising that
some information has been entered.

I therefore need the trigger to extract the information from the newly
inserted record and merge it into a plain English email.

How can this be done, knowing that there is no identity field or anything
incremented, not even a getdate() defaulted field...?

I can handle the master..xpsendmail part :)

Thanks a lot in advance for your help!

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----==  Over 80,000 Newsgroups - 16 Different Servers! =-----

Nicolas,

In your INSERT trigger, you have access to a virtual table named inserted. This contains the
rows inserted. Note that there can be several rows, so you might need a cursor to loop this
table and call xp_cmdshell from there. See Books Online for examples on triggers.

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...

Quote:> Tricky: I have a table on a SQL Server with no identity field.

> ON INSERT on a table, I need an email to be sent to somebody advising that
> some information has been entered.

> I therefore need the trigger to extract the information from the newly
> inserted record and merge it into a plain English email.

> How can this be done, knowing that there is no identity field or anything
> incremented, not even a getdate() defaulted field...?

> I can handle the master..xpsendmail part :)

> Thanks a lot in advance for your help!

> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----==  Over 80,000 Newsgroups - 16 Different Servers! =-----

Quote:> Tricky: I have a table on a SQL Server with no identity field.

> ON INSERT on a table, I need an email to be sent to somebody advising that
> some information has been entered.

> I therefore need the trigger to extract the information from the newly
> inserted record and merge it into a plain English email.

> How can this be done, knowing that there is no identity field or anything
> incremented, not even a getdate() defaulted field...?

> I can handle the master..xpsendmail part :)

I'd suggest using something other than xpsendmail.  I find it a bit quirky
and sometimes can delay things.  I believe used the way you want to use it
above it's synchronous which could cause performance issues.  I find a
product called BLAT which is a command line email util to be handy.

Quote:

> Thanks a lot in advance for your help!

> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----==  Over 80,000 Newsgroups - 16 Different Servers! =-----