--增加分类
GO
IF EXISTS(SELECT * FROM SYS_ScriptCategories WHERE id=1) 
Delete from SYS_ScriptCategories WHERE id=1
insert into SYS_ScriptCategories(ID,Code,Name,ComponentID,xRowNum,ParentID,xLevel,Description)  Values(1, 'SC1', 'HOMaster 基础管理', 1, 0, 0, 0, Null)

GO


--删除旧记录
delete from SYS_Scripts where id=19924 --删除脚本内容
GO


GO
IF EXISTS(SELECT * FROM SYS_Scripts WHERE id=19924) 
Delete from SYS_Scripts WHERE id=19924
insert into SYS_Scripts(ID,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate,UpdateUser,UpdateMode,Custom)  Values(19924, 195, 'Sql_获取医嘱期效', 'Sql_获取医嘱期效', 'Sql_获取医嘱期效', 1, 0, Null, 1, 'select VAF11 from VAF2 with(nolock) where vaf01=%d  and VAF11=1', '2020-05-26 15:02:54', '(0069)付枫', 0, 0)

GO


If EXISTS(SELECT * from Sys_CustomScripts WHERE ID = 19924)
Update a SET a.Custom = b.Custom from SYS_Scripts a join Sys_CustomScripts b on b.ID = a.ID
where a.ID=19924
GO