Generate sql mail using stored procedure

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tchangmian - 24 Sep 2004 03:37 GMT

First, i want to check for duplicate data in table. If found that have
duplicate data,the stored procedure will automatically generate a mail
to the client. Is it possible to do that? and what is the coding for
the stored procedure? Thanks

Reply to this Message

Christopher Browne - 24 Sep 2004 04:10 GMT

> First, i want to check for duplicate data in table. If found that
> have duplicate data,the stored procedure will automatically generate
> a mail to the client. Is it possible to do that? and what is the
> coding for the stored procedure? Thanks

How you would accomplish this depends heavily on what vendor you got
your SQL implementation from.

For instance, your proposal would be nonsense if you purchased your
database from MySQL AB, because their product supports neither stored
procedures nor triggers.

Other products have potential ways of accomplishing this; the
implementations of stored procedures vary widely between vendors, and
how email is submitted will vary depending on both the DBMS and the
operating system.

Signature

"cbbrowne","@","linuxfinances.info"
http://www.ntlug.org/~cbbrowne/
If you ever drop your keys into a river of molten lava, let'em go,
because, man, they're gone.

Reply to this Message

Laconic2 - 24 Sep 2004 17:50 GMT

> First, i want to check for duplicate data in table. If found that have
> duplicate data,the stored procedure will automatically generate a mail
> to the client. Is it possible to do that? and what is the coding for
> the stored procedure? Thanks

This may be a stupid question, but why don't you keep duplicates out in the
first place?

Reply to this Message