Click here to Skip to main content
15,892,697 members
Search within:


How do I develop a database birthday notification in sql server 2008 or mysql?
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL-Server
How do I develop a database birthday notification in sql server 2008 or mysql?
Posted
Add a Solution
Comments
Aadyakumar 3-Jul-14 7:06am    
Create a database with required information , then make a trigger/job for notification.Better option is a job .

1 solution

Write the required info in the database (e.g. the date of birth of every person of interest, the e-mail addresses of the notifications recipients, ...) and then notify appropriately, based on the matches of the current day of the year with the stored ones.
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
converting mysql database to sql server 2008
Migration from SQL Server 2008 to MySQL database.
How do I union multiple WITH clause in sql server 2008?
How to Convert SQL Server 2008 database into MySQL Database ?
how to import data from Mysql to Ms sql 2008 database
Converting SQL Server 2008 procedures to MYSQL
Replicate a mysql database to SQL server
Database table in SQL Server 2008
Help SQL Server 2008 R2
sql server 2008 database error

Advertise
Privacy
Cookies
Terms of Use
Last Updated 3 Jul 2014
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web04 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900