Sunday, 25 March 2018

SQL Query to Get records of Next week using SQL Server

 SQL Query to Get records of Next week using SQL Server

Description:


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

Here we demonstrate that how to get data of upcoming Next week only in SQL Server. Or select dates within the Next week date range in SQL Server.
Query:

SELECT *
FROM [dbo].[Order] WHERE [Loading Date] >=   dateadd(wk, datediff(wk, 0, getdate()) + 1, 0) AND [Loading Date] <  dateadd(wk, datediff(wk, 0, getdate())+1, 7)






This entry was posted in :

1 comments:

  1. It is really a great and useful piece of info. I’m glad that you shared this helpful info with us. Please keep us informed like this. Thank you for sharing.

    Best Dental Clinic in Nungambakkam | Painless Dental Treatment | Teeth Whitening treatment | Cosmetic Dentistry

    ReplyDelete