sql.txt

生成50年内的阴历表的sqlserver代码,能够在sqlserver中创建阴历表,并写入阴历值.

insert into YLTB values('2008-03-01','六','戊子年','鼠','正月','廿四','01','24')
insert into YLTB values('2008-03-02','日','戊子年','鼠','正月','廿五','01','25')
insert into YLTB values('2008-03-03','一','戊子年','鼠','正月','廿六','01','26')
insert into YLTB values('2008-03-04','二','戊子年','鼠','正月','廿七','01','27')
insert into YLTB values('2008-03-05','三','戊子年','鼠','正月','廿八','01','28')
insert into YLTB values('2008-03-06','四','戊子年','鼠','正月','廿九','01','29')
insert into YLTB values('2008-03-07','五','戊子年','鼠','正月','三十','01','30')
insert into YLTB values('2008-03-08','六','戊子年','鼠','二月','初一','02','01')
insert into YLTB values('2008-03-09','日','戊子年','鼠','二月','初二','02','02')
insert into YLTB values('2008-03-10','一','戊子年','鼠','二月','初三','02','03')
insert into YLTB values('2008-03-11','二','戊子年','鼠','二月','初四','02','04')
insert into YLTB values('2008-03-12','三','戊子年','鼠','二月','初五','02','05')
insert into YLTB values('2008-03-13','四','戊子年','鼠','二月','初六','02','06')
insert into YLTB values('2008-03-14','五','戊子年','鼠','二月','初七','02','07')
insert into YLTB values('2008-03-15','六','戊子年','鼠','二月','初八','02','08')
insert into YLTB values('2008-03-16','日','戊子年','鼠','二月','初九','02','09')
insert into YLTB values('2008-03-17','一','戊子年','鼠','二月','初十','02','10')
insert into YLTB values('2008-03-18','二','戊子年','鼠','二月','十一','02','11')
insert into YLTB values('2008-03-19','三','戊子年','鼠','二月','十二','02','12')
insert into YLTB values('2008-03-20','四','戊子年','鼠','二月','十三','02','13')
insert into YLTB values('2008-03-21','五','戊子年','鼠','二月','十四','02','14')
insert into YLTB values('2008-03-22','六','戊子年','鼠','二月','十五','02','15')
insert into YLTB values('2008-03-23','日','戊子年','鼠','二月','十六','02','16')
insert into YLTB values('2008-03-24','一','戊子年','鼠','二月','十七','02','17')
insert into YLTB values('2008-03-25','二','戊子年','鼠','二月','十八','02','18')
insert into YLTB values('2008-03-26','三','戊子年','鼠','二月','十九','02','19')
insert into YLTB values('2008-03-27','四','戊子年','鼠','二月','二十','02','20')
insert into YLTB values('2008-03-28','五','戊子年','鼠','二月','廿一','02','21')
insert into YLTB values('2008-03-29','六','戊子年','鼠','二月','廿二','02','22')
insert into YLTB values('2008-03-30','日','戊子年','鼠','二月','廿三','02','23')
insert into YLTB values('2008-03-31','一','戊子年','鼠','二月','廿四','02','24')
insert into YLTB values('2008-04-01','二','戊子年','鼠','二月','廿五','02','25')
insert into YLTB values('2008-04-02','三','戊子年','鼠','二月','廿六','02','26')
insert into YLTB values('2008-04-03','四','戊子年','鼠','二月','廿七','02','27')
insert into YLTB values('2008-04-04','五','戊子年','鼠','二月','廿八','02','28')
insert into YLTB values('2008-04-05','六','戊子年','鼠','二月','廿九','02','29')
insert into YLTB values('2008-04-06','日','戊子年','鼠','三月','初一','03','01')
insert into YLTB values('2008-04-07','一','戊子年','鼠','三月','初二','03','02')
insert into YLTB values('2008-04-08','二','戊子年','鼠','三月','初三','03','03')
insert into YLTB values('2008-04-09','三','戊子年','鼠','三月','初四','03','04')
insert into YLTB values('2008-04-10','四','戊子年','鼠','三月','初五','03','05')
insert into YLTB values('2008-04-11','五','戊子年','鼠','三月','初六','03','06')
insert into YLTB values('2008-04-12','六','戊子年','鼠','三月','初七','03','07')
insert into YLTB values('2008-04-13','日','戊子年','鼠','三月','初八','03','08')
insert into YLTB values('2008-04-14','一','戊子年','鼠','三月','初九','03','09')
insert into YLTB values('2008-04-15','二','戊子年','鼠','三月','初十','03','10')
insert into YLTB values('2008-04-16','三','戊子年','鼠','三月','十一','03','11')
insert into YLTB values('2008-04-17','四','戊子年','鼠','三月','十二','03','12')
insert into YLTB values('2008-04-18','五','戊子年','鼠','三月','十三','03','13')
insert into YLTB values('2008-04-19','六','戊子年','鼠','三月','十四','03','14')
insert into YLTB values('2008-04-20','日','戊子年','鼠','三月','十五','03','15')
insert into YLTB values('2008-04-21','一','戊子年','鼠','三月','十六','03','16')
insert into YLTB values('2008-04-22','二','戊子年','鼠','三月','十七','03','17')
insert into YLTB values('2008-04-23','三','戊子年','鼠','三月','十八','03','18')
insert into YLTB values('2008-04-24','四','戊子年','鼠','三月','十九','03','19')
insert into YLTB values('2008-04-25','五','戊子年','鼠','三月','二十','03','20')
insert into YLTB values('2008-04-26','六','戊子年','鼠','三月','廿一','03','21')
insert into YLTB values('2008-04-27','日','戊子年','鼠','三月','廿二','03','22')
insert into YLTB values('2008-04-28','一','戊子年','鼠','三月','廿三','03','23')
insert into YLTB values('2008-04-29','二','戊子年','鼠','三月','廿四','03','24')
insert into YLTB values('2008-04-30','三','戊子年','鼠','三月','廿五','03','25')
insert into YLTB values('2008-05-01','四','戊子年','鼠','三月','廿六','03','26')
insert into YLTB values('2008-05-02','五','戊子年','鼠','三月','廿七','03','27')
insert into YLTB values('2008-05-03','六','戊子年','鼠','三月','廿八','03','28')
insert into YLTB values('2008-05-04','日','戊子年','鼠','三月','廿九','03','29')
insert into YLTB values('2008-05-05','一','戊子年','鼠','四月','初一','04','01')
insert into YLTB values('2008-05-06','二','戊子年','鼠','四月','初二','04','02')
insert into YLTB values('2008-05-07','三','戊子年','鼠','四月','初三','04','03')
insert into YLTB values('2008-05-08','四','戊子年','鼠','四月','初四','04','04')
insert into YLTB values('2008-05-09','五','戊子年','鼠','四月','初五','04','05')
insert into YLTB values('2008-05-10','六','戊子年','鼠','四月','初六','04','06')
insert into YLTB values('2008-05-11','日','戊子年','鼠','四月','初七','04','07')
insert into YLTB values('2008-05-12','一','戊子年','鼠','四月','初八','04','08')
insert into YLTB values('2008-05-13','二','戊子年','鼠','四月','初九','04','09')
insert into YLTB values('2008-05-14','三','戊子年','鼠','四月','初十','04','10')
insert into YLTB values('2008-05-15','四','戊子年','鼠','四月','十一','04','11')
insert into YLTB values('2008-05-16','五','戊子年','鼠','四月','十二','04','12')
insert into YLTB values('2008-05-17','六','戊子年','鼠','四月','十三','04','13')
insert into YLTB values('2008-05-18','日','戊子年','鼠','四月','十四','04','14')
insert into YLTB values('2008-05-19','一','戊子年','鼠','四月','十五','04','15')
insert into YLTB values('2008-05-20','二','戊子年','鼠','四月','十六','04','16')
insert into YLTB values('2008-05-21','三','戊子年','鼠','四月','十七','04','17')
insert into YLTB values('2008-05-22','四','戊子年','鼠','四月','十八','04','18')
insert into YLTB values('2008-05-23','五','戊子年','鼠','四月','十九','04','19')
insert into YLTB values('2008-05-24','六','戊子年','鼠','四月','二十','04','20')
insert into YLTB values('2008-05-25','日','戊子年','鼠','四月','廿一','04','21')
insert into YLTB values('2008-05-26','一','戊子年','鼠','四月','廿二','04','22')
insert into YLTB values('2008-05-27','二','戊子年','鼠','四月','廿三','04','23')
insert into YLTB values('2008-05-28','三','戊子年','鼠','四月','廿四','04','24')
insert into YLTB values('2008-05-29','四','戊子年','鼠','四月','廿五','04','25')
insert into YLTB values('2008-05-30','五','戊子年','鼠','四月','廿六','04','26')
insert into YLTB values('2008-05-31','六','戊子年','鼠','四月','廿七','04','27')
insert into YLTB values('2008-06-01','日','戊子年','鼠','四月','廿八','04','28')
insert into YLTB values('2008-06-02','一','戊子年','鼠','四月','廿九','04','29')
insert into YLTB values('2008-06-03','二','戊子年','鼠','四月','三十','04','30')
insert into YLTB values('2008-06-04','三','戊子年','鼠','五月','初一','05','01')
insert into YLTB values('2008-06-05','四','戊子年','鼠','五月','初二','05','02')
insert into YLTB values('2008-06-06','五','戊子年','鼠','五月','初三','05','03')
insert into YLTB values('2008-06-07','六','戊子年','鼠','五月','初四','05','04')
insert into YLTB values('2008-06-08','日','戊子年','鼠','五月','初五','05','05')
insert into YLTB values('2008-06-09','一','戊子年','鼠','五月','初六','05','06')
insert into YLTB values('2008-06-10','二','戊子年','鼠','五月','初七','05','07')
insert into YLTB values('2008-06-11','三','戊子年','鼠','五月','初八','05','08')
insert into YLTB values('2008-06-12','四','戊子年','鼠','五月','初九','05','09')
insert into YLTB values('2008-06-13','五','戊子年','鼠','五月','初十','05','10')
insert into YLTB values('2008-06-14','六','戊子年','鼠','五月','十一','05','11')
insert into YLTB values('2008-06-15','日','戊子年','鼠','五月','十二','05','12')
insert into YLTB values('2008-06-16','一','戊子年','鼠','五月','十三','05','13')
insert into YLTB values('2008-06-17','二','戊子年','鼠','五月','十四','05','14')
insert into YLTB values('2008-06-18','三','戊子年','鼠','五月','十五','05','15')
insert into YLTB values('2008-06-19','四','戊子年','鼠','五月','十六','05','16')
insert into YLTB values('2008-06-20','五','戊子年','鼠','五月','十七','05','17')
insert into YLTB values('2008-06-21','六','戊子年','鼠','五月','十八','05','18')
insert into YLTB values('2008-06-22','日','戊子年','鼠','五月','十九','05','19')
insert into YLTB values('2008-06-23','一','戊子年','鼠','五月','二十','05','20')
insert into YLTB values('2008-06-24','二','戊子年','鼠','五月','廿一','05','21')
insert into YLTB values('2008-06-25','三','戊子年','鼠','五月','廿二','05','22')
insert into YLTB values('2008-06-26','四','戊子年','鼠','五月','廿三','05','23')
insert into YLTB values('2008-06-27','五','戊子年','鼠','五月','廿四','05','24')
insert into YLTB values('2008-06-28','六','戊子年','鼠','五月','廿五','05','25')
insert into YLTB values('2008-06-29','日','戊子年','鼠','五月','廿六','05','26')
insert into YLTB values('2008-06-30','一','戊子年','鼠','五月','廿七','05','27')
insert into YLTB values('2008-07-01','二','戊子年','鼠','五月','廿八','05','28')
insert into YLTB values('2008-07-02','三','戊子年','鼠','五月','廿九','05','29')
insert into YLTB values('2008-07-03','四','戊子年','鼠','六月','初一','06','01')
insert into YLTB values('2008-07-04','五','戊子年','鼠','六月','初二','06','02')
insert into YLTB values('2008-07-05','六','戊子年','鼠','六月','初三','06','03')
insert into YLTB values('2008-07-06','日','戊子年','鼠','六月','初四','06','04')
insert into YLTB values('2008-07-07','一','戊子年','鼠','六月','初五','06','05')
insert into YLTB values('2008-07-08','二','戊子年','鼠','六月','初六','06','06')
insert into YLTB values('2008-07-09','三','戊子年','鼠','六月','初七','06','07')
insert into YLTB values('2008-07-10','四','戊子年','鼠','六月','初八','06','08')
insert into YLTB values('2008-07-11','五','戊子年','鼠','六月','初九','06','09')
insert into YLTB values('2008-07-12','六','戊子年','鼠','六月','初十','06','10')
insert into YLTB values('2008-07-13','日','戊子年','鼠','六月','十一','06','11')
insert into YLTB values('2008-07-14','一','戊子年','鼠','六月','十二','06','12')
insert into YLTB values('2008-07-15','二','戊子年','鼠','六月','十三','06','13')
insert into YLTB values('2008-07-16','三','戊子年','鼠','六月','十四','06','14')
insert into YLTB values('2008-07-17','四','戊子年','鼠','六月','十五','06','15')
insert into YLTB values('2008-07-18','五','戊子年','鼠','六月','十六','06','16')
insert into YLTB values('2008-07-19','六','戊子年','鼠','六月','十七','06','17')
insert into YLTB values('2008-07-20','日','戊子年','鼠','六月','十八','06','18')
insert into YLTB values('2008-07-21','一','戊子年','鼠','六月','十九','06','19')
insert into YLTB values('2008-07-22','二','戊子年','鼠','六月','二十','06','20')
insert into YLTB values('2008-07-23','三','戊子年','鼠','六月','廿一','06','21')
insert into YLTB values('2008-07-24','四','戊子年','鼠','六月','廿二','06','22')
insert into YLTB values('2008-07-25','五','戊子年','鼠','六月','廿三','06','23')