sql.txt

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

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