34,838
社区成员




----example
create table tab(ID int,Name varchar(10),code varchar(10),[Datetime] datetime)
insert tab
select 1,'aa','aaa','2006-01-05'
union select 2,'bb','bbb','2007-10-12'
union select 2,'bb','bbb','2007-11-12'
union select 2,'bb','bbb','2007-12-12'
union select 2,'bb','bbb','2008-12-12'
declare @year varchar(4) , @month varchar(4)
select @year='2007',@month='12'
select * from tab where DATEDIFF(month,[Datetime] ,cast(@year+'-'+@month+'-'+'01' as datetime)) >=0
drop table tab
/* 结果
ID Name code Datetime
----------- ---------- ---------- ------------------------------------------------------
1 aa aaa 2006-01-05 00:00:00.000
2 bb bbb 2007-10-12 00:00:00.000
2 bb bbb 2007-11-12 00:00:00.000
2 bb bbb 2007-12-12 00:00:00.000
(所影响的行数为 4 行)
*/