sql.txt

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

Create Table YLTB(
	阳历日期	varchar(10)  NOT NULL ,
	星期	varchar(2)  NOT NULL ,
	干支	varchar(10)  NOT NULL ,
	生肖	varchar(2)  NOT NULL ,
	阴历月	varchar(10)  NOT NULL ,
	阴历日	varchar(10)  NOT NULL ,
	阴历Month	varchar(10)  NOT NULL ,
	阴历Day	varchar(10)  NOT NULL 
)

GO
ALTER TABLE YLTB ADD  PRIMARY KEY  clustered 
   ( 阳历日期 )  ON [PRIMARY]

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