查询年与年之间的月份差.

Question

...
where 年 + left('00'+cast(月 as varchar),2) between cmbYear1 + cmbMonth1 and cmbYear2 + cmbMonth2cmbMonth必须是两位,如：
'01'、'05'

Answer 1

(cmbYear2 - cmbYear1) * 12 + (cmbMonth2 - cmbMonth1)

Answer 2

估計是想查範圍的...
where 
convert(datetime,right(10000+年,4)+right(100+月,2)+right(100+日,2))>=
convert(datetime,cmbYear1+'-'+cmbMonth1+'-'+'01')
and convert(datetime,right(10000+年,4)+right(100+月,2)+right(100+日,2))<
convert(datetime,cmbYear2+'-'+(1+cmbMonth2)+'-'+'01')