肇启涛的专栏

delete bminsert bm values('01','一站')insert bm values('02','二站')insert bm values('03','三站')insert bm values('04','四站')insert bm values('05','五站')insert bm values('06','六站')insert bm value

declare @date1 varchar(10),@date2 varchar(10)set @date1='2013-10-20'set @date2='2013-10-21'select mon= (case when Day(@date2) > DAY(@date1) then datediff(month,@date1,@date2) + 1    else dat