Error Restricting Dates in SQL Server

3

I get 3 bases that are mounted in different places, these bases come to me in text file (.txt) and I do the import to SQL Server.

I'm doing a query in which I want to restrict the records only for the year 2014 but even putting Data >= '01/01/2014' it keeps appearing records for 2012 and 2013.

    
asked by anonymous 21.11.2014 / 13:43

1 answer

2

Test this

YEAR(Data) IN '2014'
    
21.11.2014 / 14:12