SQL2005查询时的字段类型转换

SELECT count(id)
FROM [xiaoshuo2008].[dbo].[Ws_BookList]
where convert(varchar(4),bookaddtime,120) = ‘2008’

Down load the sql.sqlquery3