delete vs4tsystem WHERE tsysname='LSCCustom1'
GO
insert into vs4tsystem (tsysid,tsysname,tsystext,tsysvalue,tsysflag1) values (-1,'LSCCustom1','หมายเลขเครื่อง',0,1)
GO
update vs4tsystem set tsysid=(select max(tsysid)+1 from vs4tsystem) where tsysid=-1
GO

delete vs4tsystem WHERE tsysname='LSCCustom2'
GO
insert into vs4tsystem (tsysid,tsysname,tsystext,tsysvalue,tsysflag1) values (-1,'LSCCustom2','หมายเลขแชสซี',0,1)
GO
update vs4tsystem set tsysid=(select max(tsysid)+1 from vs4tsystem) where tsysid=-1
GO

delete vs4tsystem WHERE tsysname='LSCCustom3'
GO
insert into vs4tsystem (tsysid,tsysname,tsystext,tsysvalue,tsysflag1) values (-1,'LSCCustom3','ทะเบียน',0,1)
GO
update vs4tsystem set tsysid=(select max(tsysid)+1 from vs4tsystem) where tsysid=-1
GO

delete vs4tsystem WHERE tsysname='LSCCustom4'
GO
insert into vs4tsystem (tsysid,tsysname,tsystext,tsysvalue,tsysflag1) values (-1,'LSCCustom4','ยี่ห้อเครื่อง',0,1)
GO
update vs4tsystem set tsysid=(select max(tsysid)+1 from vs4tsystem) where tsysid=-1
GO

delete vs4tsystem WHERE tsysname='LSCCustom5'
GO
insert into vs4tsystem (tsysid,tsysname,tsystext,tsysvalue,tsysflag1) values (-1,'LSCCustom5','สถานที่ใช้',0,1)
GO
update vs4tsystem set tsysid=(select max(tsysid)+1 from vs4tsystem) where tsysid=-1
GO
