UPDATE VS4TSystem Set TSysText='SO' WHERE TSysName='SOJOBBook'
GO
UPDATE VS4TJob Set TJobTJBKCode='SO' WHERE TJobType=4
GO
UPDATE VS4TSystem Set TSysText='SE' WHERE TSysName='SEJOBBook'
GO
UPDATE VS4TJob Set TJobTJBKCode='SE' WHERE TJobType=3
GO
UPDATE VS4TSystem Set TSysText='RO' WHERE TSysName='ROJOBBook'
GO
UPDATE VS4TJob Set TJobTJBKCode='RO' WHERE TJobType=5
GO

delete vs4tsystem WHERE tsysname='SE2SPJOBBook'
GO
insert into vs4tsystem (tsysid,tsysname,tsystext,tsysvalue,tsysflag1) values (-1,'SE2SPJOBBook','TR',0,1)
GO
update vs4tsystem set tsysid=(select max(tsysid)+1 from vs4tsystem) where tsysid=-1
GO
delete vs4tsystem WHERE tsysname='VI2SPJOBBook'
GO
insert into vs4tsystem (tsysid,tsysname,tsystext,tsysvalue,tsysflag1) values (-1,'VI2SPJOBBook','TR',0,1)
GO
update vs4tsystem set tsysid=(select max(tsysid)+1 from vs4tsystem) where tsysid=-1
GO
UPDATE VS4TJob Set TJobTJBKCode='TR' WHERE TJobType=2
GO