--在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
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