360lj_MemberdataETL/dataimportMem.sql

select count(1) from dataimport

select max(cast(id  as int)) from dataimport

select count(1) from mem_Product

exec createEntity 'mem_terminaldoc'


alter table mem_RoleRelatePermission drop column ID1 
alter table mem_RoleRelatePermission add ID1 int identity(1,1)
 SET IDENTITY_INSERT mem_RoleRelatePermission ON	
update mem_RoleRelatePermission set ID1= id

select count(1) from dataimport a where exists (select b.DataId from dataimport_mem b where b.DataId = DataId )
select count(distinct a.Id) from dataimport a left join dataimport_mem b on b.DataId = a.DataId 
where b.dataid is not null


select * from dataimport where