Now generally available, SQL Server 2022's feature set brings it closer to parity with Azure SQL. Here are the biggest additions to Microsoft's RDBMS software you need to know.

You can do table returning functions in sql server 2000 onwards so doing one to give you a table between two dates sould be easy enough.

Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

Learn how Data Transformation Services (DTS) can help you import, export, and/or transform data from various sources to single or multiple locations in Microsoft SQL Server 2000.