--这样?
declare @t table([date] datetime)
insert into @t select '2005-01-02'
insert into @t select '2005-03-02'
insert into @t select '2006-04-02'
insert into @t select '2005-01-03'select * from @t where convert(varchar(7),[date],120) like '2006-04'
declare @t table([date] datetime)
insert into @t select '2005-01-02'
insert into @t select '2005-03-02'
insert into @t select '2006-04-02'
insert into @t select '2005-01-03'select * from @t where convert(varchar(7),[date],120) like '2006-04'
这样写select * from 表 where convert(varchar(10),列,120) like '2006-04'+'%'