CNCEC_SUBQHSE_WUHUAN/DataBase/版本日志/SUBQHSE_V2025-03-26-geh.sql

5 lines
238 B
Transact-SQL

UPDATE [dbo].[HSSE_Hazard_HazardRegister] SET [Risk_Level] = '一般' WHERE Risk_Level is null or Risk_Level = '';
go
UPDATE [dbo].[HSSE_Hazard_HazardRegister] SET [ProblemTypes] = '0' WHERE ProblemTypes is null or Risk_Level = '';
go