1.新建数据库,表(涉及跨月跨年)
2.统计原始表数据,插入到新的库里面

SQL Server：取当前年月
SELECT FORMAT(GETDATE(), ‘yyyyMM’) AS CurrentYearMonth;

上一个月
SELECT FORMAT(DATEADD(MONTH, -1, GETDATE()), ‘yyyyMM’) AS LastMonth;

SQL Server判断表是否存在

https://www.microsoft.com/zh-cn/sql-server/sql-server-downloads

sql server安装
https://www.bilibili.com/video/BV1DsfPYEEaZ/?spm_id_from=333.337.search-card.all.click&vd_source=fd8128ae42b35905c9fc821432f9a40e

ssms下载
https://learn.microsoft.com/zh-cn/ssms/release-history
https://learn.microsoft.com/zh-cn/ssms/release-notes-20

xp系统资源下载
https://www.microsoft.com/zh-CN/download/details.aspx?id=30438