how to get records of Next Year using SQL Server.

Description:

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

Here we demonstrate that how Select Next Year or Upcoming Year records using SQL Server. Or how to get Next Year from SQL Server.

Query:

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