a

delete froM EMR_BLWJJGNRK a(nolock)
right join [DY_HIS].[CISDBDATA_DY_ODS].[dbo].[EMR_BLWJJGNRK] b(nolock) 
on a.qtbljlxh = b.QTBLJLXH
where a.qtbljlxh is null

select distinct b.SYXH froM EMR_BLWJJGNRK a(nolock)
right join [DY_HIS].[CISDBDATA_DY_ODS].[dbo].[EMR_BLWJJGNRK] b(nolock) 
on a.qtbljlxh = b.QTBLJLXH
where a.qtbljlxh is null

select COUNT(1) from VW_LSYZK a(nolock)
right join [DY_HIS].[THIS4_DY_ODS].[dbo].[VW_LSYZK] b(nolock) 
on a.xh = b.xh
where a.xh is null

 

SELECT * FROM CM_TIMESTEMP_MANAGEMENT
WHERE tablename = 'EMR_BLWJJGNRK'

SELECT * froM CM_TIMESTEMP_MANAGEMENT
WHERE tablename = 'CDR_LCWD_WDDSJ_ZY'

SELECT * froM CM_TIMESTEMP_MANAGEMENT
WHERE tablename = 'CDR_LCWD_WDDSJ_MZ'

SELECT * froM CM_TIMESTEMP_MANAGEMENT
WHERE tablename = 'CDR_LCWD_ZY'

SELECT * froM CM_TIMESTEMP_MANAGEMENT
WHERE tablename = 'CDR_LCWD_MZ'

begin tran
UPDATE CM_TIMESTEMP_MANAGEMENT  SET startime = 0 WHERE tablename = 'CDR_LCWD_MZ'
UPDATE CM_TIMESTEMP_MANAGEMENT  SET startime = 0 WHERE tablename = 'CDR_LCWD_ZY'
UPDATE CM_TIMESTEMP_MANAGEMENT  SET startime = 0 WHERE tablename = 'CDR_LCWD_WDDSJ_MZ'
UPDATE CM_TIMESTEMP_MANAGEMENT  SET startime = 0 WHERE tablename = 'CDR_LCWD_WDDSJ_ZY'
UPDATE CM_TIMESTEMP_MANAGEMENT  SET startime = 0 WHERE tablename = 'EMR_BLWJJGNRK'
rollback tran