10 lines
885 B
Transact-SQL
10 lines
885 B
Transact-SQL
UPDATE dbo.Editor_EProject SET Permit_PPA_ProjectRegistration=NULL WHERE Permit_PPA_ProjectRegistration='1900-01-01 00:00:00.000'
|
|
UPDATE dbo.Editor_EProject SET Permit_PPA_FFDesignReview=NULL WHERE Permit_PPA_FFDesignReview='1900-01-01 00:00:00.000'
|
|
UPDATE dbo.Editor_EProject SET Permit_PA_ConstPermit=NULL WHERE Permit_PA_ConstPermit='1900-01-01 00:00:00.000'
|
|
UPDATE dbo.Editor_EProject SET Permit_PA_SafetyFinalACC=NULL WHERE Permit_PA_SafetyFinalACC='1900-01-01 00:00:00.000'
|
|
UPDATE dbo.Editor_EProject SET Permit_PA_EnvFinalACC=NULL WHERE Permit_PA_EnvFinalACC='1900-01-01 00:00:00.000'
|
|
UPDATE dbo.Editor_EProject SET SQIB_PressureVessel=NULL WHERE SQIB_PressureVessel='1900-01-01 00:00:00.000'
|
|
UPDATE dbo.Editor_EProject SET SQIB_SQIB=NULL WHERE SQIB_SQIB='1900-01-01 00:00:00.000'
|
|
UPDATE dbo.Editor_FCRLog SET ConReturnDate=NULL WHERE ConReturnDate='1900-01-01 00:00:00.000'
|
|
GO
|