如何对日期进行查询 :
select * from aa where convert(char(4),日期字段,120) ='2005'
select * from aa where convert(char(10),日期字段,120) like '2005%'
select * from aa where year(日期字段) = '2005'
select * from aa where datepart(year,日期字段)=2005
请参考 sql server 联机丛书