卷宗添加争议焦点数据制造脚本(卷宗部分)

本脚本只是制造卷宗部分添加的争议焦点,不包括分析和庭中法官添加的争议焦点。


/****** 查找案件信息———————注意案件信息一定需要在卷宗系统中存在 ******/
SELECT TOP 1000 *
FROM [Ldt_JudgeDoc].[dbo].[CS_Case] where CaseID = '3887519621942607872' or CaseCode=''

/****** 查找库中已存在争议焦点 ******/
SELECT TOP 1000 *
FROM Ldt_JudgeDoc.[dbo].CS_FocusOutline a ,Ldt_JudgeDoc.dbo.CS_Files_FocusOutlineRel ar
where a.FO_ID = ar.FO_ID order by a.FO_ID desc

/****** 更新CaseId ******/
update Ldt_JudgeDoc.[dbo].CS_FocusOutline set CaseID= '3887519621942607872'
where FO_ID in(
'FO_ID2101181519170001')

update Ldt_JudgeDoc.[dbo].CS_FocusOutline set CaseID = '3887519621942607872'
where FO_ID in(
'FO_ID2101181519170001')

/****** 获取案件证据材料信息 ******/
SELECT TOP 1000 *
FROM Ldt_JudgeDoc.[dbo].CS_FocusOutline a ,Ldt_JudgeDoc.dbo.CS_Files_FocusOutlineRel ar
where a.FO_ID = ar.FO_ID and a.CaseID='3887519621942607872'

【推广】 免费学中医,健康全家人
原文地址:https://www.cnblogs.com/xiaoguozi/p/14518234.html