SQL动态语句不能执行，求高手！！

Question

SQL 动态语句

Answer 1

把exec @sql 修改为 exec(@sql):Create Procedure [dbo].[P_transfer_photo_test]
(
@Month_id Varchar(6)
)
As
Begin

Declare @Sql Varchar(4000)
    
Create Table #Fact_Temp_POP_User_Raw_Data(
                                Raw_id int identity(1, 1),
                                Data_id int NULL,
Submit_Date varchar(50) NULL,
                                User_id int NULL,
                                POPDB_id int NULL,
Chain_Group_id int NULL,
Chain_id int NULL,
Channel_id int NULL,
Client_POP_id varchar(50) NULL,
POP_Name varchar(500) NULL,
POP_Address varchar(1000) NULL,
Source_Type varchar(50) NULL,
Task_Group varchar(1000) NULL,
Category_id int NULL,
Subcategory_id int NULL,
SKU_Cluster_id int NULL,
Brand_id int NULL,
                                SKU varchar(500) NULL,
                                Quest_Task varchar(500) NULL,
                                Data_SubTask varchar(500) NULL,
                                Subtask_Value varchar(1000) NULL,
                                Subtask_Type varchar(1000) NULL,
                                City_id int NULL,
                                District_Value varchar(50) NULL,
                                Region_Value varchar(50) NULL,
                                Area_Value varchar(50) NULL
)    -- Load photo data into temporary table
    Set @Sql = 'Insert Into #Fact_Temp_POP_User_Raw_Data 
  (Data_id, Submit_Date, User_id, POPDB_id, Chain_Group_id, Chain_id, Channel_id, Client_POP_id, POP_Name, 
   POP_Address, Source_Type, Task_Group, Category_id, Subcategory_id, SKU_Cluster_id, Brand_id, SKU, Quest_Task, 
   Data_SubTask, Subtask_Value, Subtask_Type, City_id, District_Value, Region_Value, Area_Value)
                Select Data_id, Submit_Date, User_id, POPDB_id, Chain_Group_id, Chain_id, Channel_id, Client_POP_id, POP_Name, 
                       POP_Address, Source_Type, Task_Group, Category_id, Subcategory_id, SKU_Cluster_id, Brand_id, SKU, Quest_Task, 
                       Data_SubTask, Subtask_Value, Subtask_Type, City_id, District_Value, Region_Value, Area_Value
                From MonitorNestleHK_ICE.dbo.Fact_' + @Month_id + 'M_POP_User_Raw_Data Where Subtask_Type = ''拍照''' 
    
    --修改这个
    Exec(@Sql)End

Answer 2

Anyway, thanks a lot