select构造insert语句的脚本

--在60.11执行
select 'INSERT INTO dbo.sfa_t_TPlaVisitPlan
        ( usernumber ,
          UserName ,
          VisitDate ,
          ExecuteStatus ,
          CheckStatus ,
          WorkTips ,
          CheckContent ,
          Remark ,
          EnterpriseNumber ,
          CreateOp ,
          CreateTime ,
          UpdateOp ,
          UpdateTime ,
          CheckOp ,
          CheckTime,
    a_id
        )
VALUES   (
 '  
 +           
   
    ISNULL('''' + cast([usernumber] as varchar) + ''',', 'null,') +
    ISNULL('''' + cast([UserName] as varchar) + ''',', 'null,') +
    ISNULL('''' + cast([VisitDate] as varchar)+ ''',', 'null,') +
    ISNULL('''' + cast([ExecuteStatus] as varchar)+ ''',', 'null,') +
    ISNULL('''' + cast([CheckStatus] as varchar)+ ''',', 'null,') +
    ISNULL('''' + cast([WorkTips] as varchar)+ ''',', 'null,') +
    ISNULL('''' + cast([CheckContent] as varchar)+ ''',', 'null,') +
    ISNULL('''' + cast([Remark] as varchar)+ ''',', 'null,') +
    ISNULL('''' + cast([EnterpriseNumber] as varchar)+ ''',', 'null,') +
    ISNULL('''' + cast([CreateOp] as varchar)+ ''',', 'null,') +
    ISNULL('''' + cast([CreateTime] as varchar)+ ''',', 'null,') +
    ISNULL('''' + cast([UpdateOp] as varchar)+ ''',', 'null,') +
    ISNULL('''' + cast([UpdateTime] as varchar)+ ''',', 'null,') +
    ISNULL('''' + cast([CheckOp] as varchar)+ ''',', 'null,') +
    ISNULL('''' + cast([CheckTime] as nvarchar(50)) + ''',', 'null,') +
    ISNULL('''' + cast(VisitplanID as varchar)+ ''');', 'null);
 '
 ) as xxx
 from xw_dl_1007724.dbo.sfa_t_tplavisitplan where visitplanid >= 12951