Table Name : Period
period start_date end_date
JAN-02 2002-01-01 00:00:00 2002-01-31 00:00:00
FEB-02 2002-02-01 00:00:00 2002-02-28 00:00:00
MAR-02 2002-03-01 00:00:00 2002-03-31 00:00:00
APR-02 2002-04-01 00:00:00 2002-04-30 00:00:00
MAY-02 2002-05-01 00:00:00 2002-05-31 00:00:00
JUN-02 2002-06-01 00:00:00 2002-06-30 00:00:00
JUL-02 2002-07-01 00:00:00 2002-07-31 00:00:00
AUG-02 2002-08-01 00:00:00 2002-08-31 00:00:00
SEP-02 2002-09-01 00:00:00 2002-09-30 00:00:00
OCT-02 2002-10-01 00:00:00 2002-10-31 00:00:00
NOV-02 2002-11-01 00:00:00 2002-11-30 00:00:00
DEC-02 2002-12-01 00:00:00 2002-12-31 00:00:00
Currently on first of each new month I add a row i.e.
on January 01,2003 I will add a row like this
JAN-03 2003-01-01 00:00:00 2003-01-31 00:00:00
Is it possible that at beginning of each new month one
row is inserted into table period automatically.
If possible then what will be the good event.
1. When sql server starts.
2. When database is connected.
3. When database is accessed.
4. When the particular table (period) is accessed.
5. or any other event
Start Free Trial