--增加分类
GO
IF not EXISTS(SELECT * FROM SYS_ScriptCategories WHERE id=95)
insert into SYS_ScriptCategories(ID,Code,Name,ComponentID,xRowNum,ParentID,xLevel,Description)  Values(95, 'HO.Mem', '会员管理系统', 116, 0, 0, 0, Null)
else
print 'SYS_ScriptCategories.id=95 已经存在.'

GO


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


GO
IF not EXISTS(SELECT * FROM SYS_Scripts WHERE id=6468)
insert into SYS_Scripts(ID,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate,UpdateUser,UpdateMode)  Values(6468, 95, 'MEM_CRM转换病人', 'CRM转换病人信息', 'CRM转换病人信息', 1, 1, Null, 1, 'DECLARE @VAA01 int = %d, @SCA01 int = %d

 if @VAA01>0
 begin
  SELECT
   A.VAA01, 
   A.VAA02, 
   A.VAA03, 
   A.VAA04, 
   A.VAA05, 
   A.ABW01, 
   A.VAA10, 
   A.AAU01,
   A.VAA12,
   A.VAA15,
   A.ABQ02,
   A.VAA33,
   A.ABC02,
   A.VAA34,
   A.VAA35,
   A.BDX02,
   A.VAA47
  FROM
   VAA1 A with(nolock) 
  where a.vaa01=@vaa01 and a.VBU01 = 0 
 end
 else begin
   SELECT
   0 VAA01, 
   NULL VAA02, 
   NULL VAA03, 
   NULL VAA04, 
   A.SCA06 VAA05, 
   A.ABW01, 
   A.sca12 VAA10, 
   A.AAU01,
   A.sca11 VAA12,
   A.SCA22 VAA15,
   A.ABQ02,
   A.SCA17 VAA33,
   NULL ABC02,
   A.SCA25 VAA34,
   A.SCA26 VAA35,
   A.sca30 BDX02,
   A.sca24 VAA47
  FROM
   SCA1 A  with(nolock)
  where a.SCA01=@SCA01
 end', '2016-09-12 11:09:23', '(8065)冯义强', 0)
else
print 'SYS_Scripts.id=6468 已经存在.'

GO