/******
ѯñ仯 Author:wyw  
2023-04-26
*******/

-- yyyy-MM-dd 00:00:00 Ϊµ
select top 100 MODIFY_TIME, * from  T_PF_FORM  order  by T_PF_FORM.MODIFY_TIME desc



declare @MODIFY_TIME datetime
set @MODIFY_TIME='2024-08-27 00:00:01'

--ѯб仯ı
select T_PF_FORM.CODE,T_PF_FORM.NAME from T_PF_EDIT_COLUMN
inner join T_PF_PAGE_EDIT on T_PF_PAGE_EDIT.ID=T_PF_EDIT_COLUMN.PAGE_EDIT_ID
inner join T_PF_FORM on T_PF_FORM.ID=T_PF_PAGE_EDIT.PAGE_FORM_ID
where T_PF_EDIT_COLUMN.MODIFY_TIME>@MODIFY_TIME
group by T_PF_FORM.CODE ,T_PF_FORM.NAME
union all
--ѯб仯б
select T_PF_FORM.CODE ,T_PF_FORM.NAME from  T_PF_COLUMN 
inner join T_PF_PAGE_TABLE on T_PF_COLUMN.PAGE_TABLE_ID=T_PF_PAGE_TABLE.ID
inner join T_PF_FORM on T_PF_FORM.ID=T_PF_PAGE_TABLE.PAGE_FORM_ID
where T_PF_COLUMN.MODIFY_TIME>@MODIFY_TIME
group by T_PF_FORM.CODE ,T_PF_FORM.NAME
union all
--ѯб仯
select  T_PF_FORM.CODE ,T_PF_FORM.NAME  from T_PF_QUERY
inner join T_PF_FORM on T_PF_FORM.ID=T_PF_QUERY.PAGE_FORM_ID
where T_PF_QUERY.MODIFY_TIME>@MODIFY_TIME
group by T_PF_FORM.CODE ,T_PF_FORM.NAME
union all
--ѯб仯õı
select  T_PF_FORM.CODE ,T_PF_FORM.NAME  from T_PF_PAGE_CUSTOM
inner join T_PF_FORM on T_PF_FORM.ID=T_PF_PAGE_CUSTOM.PAGE_FORM_ID
where T_PF_PAGE_CUSTOM.MODIFY_TIME>@MODIFY_TIME
group by T_PF_FORM.CODE ,T_PF_FORM.NAME
union all
--ѯб仯İť
select T_PF_FORM.CODE ,T_PF_FORM.NAME from  T_PF_BTN 
inner join T_PF_PAGE_TABLE on T_PF_BTN.PAGE_TABLE_ID=T_PF_PAGE_TABLE.ID
inner join T_PF_FORM on T_PF_FORM.ID=T_PF_PAGE_TABLE.PAGE_FORM_ID
where T_PF_BTN.MODIFY_TIME>@MODIFY_TIME
group by T_PF_FORM.CODE ,T_PF_FORM.NAME
order by CODE

--ظѯ
select * from  (
select count(1)as CodeCount, CODE,NAME from  T_PF_FORM 
group by CODE,NAME
) tb where tb.CodeCount>1
order  by CODE desc


