-- 获得当月天数  
     select   day ( dateadd (mm, 1 , getdate ()) - day ( getdate ()))  as  本月天数 ;  
     select   getdate ()  as  当前日期;  
     select   day ( getdate ())  as  目前第几天;  
     select   getdate () - day ( getdate ())   as  上个月最后一天;  --  减去了当前的天数  
     select   dateadd (mm, 1 , getdate ()) - day ( getdate ())  as  加上一个月;  --  也就是这个月的最后一天  
     select   day ( dateadd (mm, 1 , getdate ()) - day ( getdate ()))  as  获得当月天数;