SQL按年月创建动态表

/****** Object:  StoredProcedure [dbo].[maintain_DataCsvTable]    Script Date: 2022/8/12 11:50:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        <Team QIUBB>
-- Create date: <2022.08.10>
-- Description:    创建数据库动态表（表名为动态表名DataCsv+年+月）
-- =============================================
ALTER PROCEDURE [dbo].[maintain_DataCsvTable]      
AS      
BEGIN     
 --按照要求生成DataCsv+年月的表名---
 declare @tablename nvarchar(50)      
 set @tablename='DataCsv'       
 --set @tablename=@tablename+cast(datepart(year,GETDATE()) as nvarchar(50))+cast(DATEPART(MONTH,GETDATE()) as nvarchar(50))      
 SET @tablename = @tablename+LEFT(CONVERT(CHAR(8), GETDATE(),112),6)    
 --select @tablename       
 execute ('CREATE TABLE '+@tablename+'(       
    [DataCsvId] [char](12) NOT NULL,      
 [HostNumber] [varchar](100) NULL,      
 [DetectionTime] [datetime] NULL,      
 [ProductQRCode] [varchar](500) NULL,      
 [ProductCode] [varchar](500) NULL,      
 [TestTtems] [varchar](500) NULL,      
 [RelativeVUnit] [varchar](50) NULL,      
 [AbsoluteVUnit] [varchar](50) NULL,      
 [UpperLimit] [decimal](18, 4) NULL,      
 [LowerLimit] [decimal](18, 4) NULL,      
 [NominalValue] [decimal](18, 4) NULL,      
 [RelatValue] [decimal](18, 4) NULL,      
 [AbsoluteValue] [decimal](18, 4) NULL,      
 [States] [char](20) NULL, ) ON [PRIMARY] ')       
END