sql.txt

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

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