sql.txt

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

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