SQL Server存储过程中的sql语句拼接执行

ALTER PROCEDURE [dbo].[Proc_CaseRemark_ADD]
@RecordID bigint,
@CaseId nvarchar(20),
@Remark nvarchar(1000),
@IDCardNo nvarchar(50),
@CreateUser nvarchar(20),
@MeMoType int,
@IsUse nvarchar(2),
@CreateTime datetime

 AS 
BEGIN

    SET NOCOUNT ON;
    Declare @xvalue nvarchar(10)
    Declare @CustName nvarchar(20)
    Declare @strSql nvarchar(1000)
    Declare @IRecordId nvarchar(30)
    select @IDCardNo=idcardno,@CustName=DebtorName from [case] where caseid=@CaseId
    --select @IDCardNo=(select idcardno from [case] where caseid=@CaseId)
    --select @CustName =(select DebtorName from [case] where caseid=@CaseId)

    INSERT INTO [Case_Remark](
    [CaseId],Remark,IDCardNo,CreateUser,CreateTime,CustName,MeMoType,IsUse
    )VALUES(
    @CaseId,@Remark,@IDCardNo,@CreateUser,getdate(),@CustName,@MeMoType,@IsUse
    )
    
    select @IRecordId = @@IDENTITY
    -- 根据MEMOTYPE去查询值
    select @xvalue=StateCode from T_V_Parameter where patype=17 and vid=@MeMoType
    if exists(select StateCode from T_V_Parameter where patype=17 and vid=@MeMoType)
    begin

      set @strSql = 'Insert into [Case_Remork_Recording](CaseID,CreateTime,RecordId,'+@xvalue+') values
      ('''+@CaseId+''',getdate(),Convert(bigint,'+ @IRecordId + '),1)'
    end
    print(@strSql)
    exec( @strSQL) 
END