ALTER TABLE VS4TJobMethod ADD
	TJStProcessStatus smallint NULL
GO
UPDATE VS4TJobMethod Set TJStProcessStatus=0 WHERE TJStProcessStatus is null
GO
UPDATE VS4TJobMethod Set TJStProcessStatus=1 WHERE TJStTJPDNo <> '' and TJStTJPDNo is not null 
GO
