--增加分类
GO
IF not EXISTS(SELECT * FROM SYS_ScriptCategories WHERE id=47)
insert into SYS_ScriptCategories(ID,Code,Name,ComponentID,xRowNum,ParentID,xLevel,Description)  Values(47, 'SC47', '手术工作站', 18, 0, 46, 0, Null)
else
print 'SYS_ScriptCategories.id=47 已经存在.'

GO


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


GO
IF not EXISTS(SELECT * FROM SYS_Scripts WHERE id=16844)
insert into SYS_Scripts(ID,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate,UpdateUser,UpdateMode)  Values(16844, 47, 'SQL_手术医生', 'SQL_手术医生', 'SQL_手术医生', 1, 0, Null, 1, 'select VAX01,VAT01,VAY03,BCK01,ACE01,BCE01,BCE02,BCE03 from VAX1
WHERE VAT01 = %0:d', '2016-01-28 10:25:49', '(00399)张豪', 0)
else
print 'SYS_Scripts.id=16844 已经存在.'

GO