declare?@Date?datetime<br/>set?@Date?=?'2007/05/05'<br/>SELECT?datediff(d,?@Date,?dateadd(m,1,?@Date))<br/><br/>（下月今天-本月今天）/天?=?本月最大天数。<br/>------------------<br/>Really?<br/>Just?test?"@Date?=?'2007/05/31'",?then?your?answer?is?30,?it's?wrong!

gu 回复于 2007-09-10

thank?you?for?your?remind?,?correct:?SELECT?datediff(d,?@Date,?dateadd(d,day(@Date),?@Date))<br/>Is?that?true?<br/>