Select records for Current Year in SQL Server .

Description:

In this example we explain that how to get records of This Year using SQL Server. Or SQL Query to get the Current Year record in SQL Server. Or SQL Query to return all records from This Year using SQL Server. Or SQL query to select all records created in This Year. Or how to retrieve Current Year date values in SQL Server.

Here we demonstrate that how Select Current Year or This Year records using SQL Server. Or how to get current Year from SQL Server.

Query:

SELECT * FROM [dbo].[Order] WHERE   YEAR([Loading Date]) = YEAR(GEtdate())