(Triggers)match win/lose trigger Send UPdated Email in sql server

• Database admin(DBA)

  SSCertifiable

  Points: 5373

  More actions

  April 17, 2012 at 3:43 am

  #267459

  Hi all,

  how to write trigger Match win\lose\draw send Email for Users.

  For Example:india vs Aus match..here when user Asked to me india win\lose\draw\tie the Match Updated on send on Email.

  is it possible?? win and loss or drawn in Match send Updated Mail to User(i mean Match will be started on 4PM and Ending on 8Pm.This situation 7.59PM india win the Match i.e.,automatic updated on user Email or mobile..how????????

  pls suggest me on send Email????????????????

  SQL server DBA

• Mike01

  SSChampion

  Points: 11420

  More actions

  April 17, 2012 at 7:00 am

  #1474694

  can you provide some ddl and what your expected results are?

  For better, quicker answers, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/