94 lines
7.5 KiB
Transact-SQL
94 lines
7.5 KiB
Transact-SQL
alter table Comprehensive_DataReceivingDoc alter column RemarkCode int
|
||
go
|
||
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='¸Ö½îHRB400E'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='Y200430832'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='ÒÑÈ¡ÑùËͼì'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='Y1109024'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='GB8624-2014'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='CV'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='GB/T5574-2008'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='J1009194'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='B201031625'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='GB50264-2013'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='QC202108241813'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='GB8624-2016'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='Q355'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='A537CL2'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='EQ001'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='GB/T3880-2012'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='SS2022-00150'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='F1112193'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='AFJ2207444'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='A02212507RPS1'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='¸Ö½îHPB300'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='A537CL2/A516 Cr 60/Q370/Q345'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='J1012004'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='A537 CL2/Q370/Q345'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='SANS298-2007'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='SS2022-00006'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='jc/70-2002'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='AFJ22070445'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='GB8624-2015'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='8900002955433'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='GB8624-2013'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='Q370/Q345'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='Y1201023'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-92'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='0-116'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-195'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='0-9'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-197'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-65'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-188'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='0-107'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-125'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-130'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-43'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='0-102'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='ÓÐÖÊÁ¿Ö¤Ã÷Îļþ'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-16'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-78'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-219'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-74'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='0-14'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='0-20'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='0-182'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='0-159'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-114'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-249'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='J1011003'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='GB8624-2012'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-173'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-294'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='0-22'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-289'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-116'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='½ËÕ¶«ÅôÐÂÐͽ¨²ÄÓÐÏÞ¹«Ë¾'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-104'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='0-131'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='0-140'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='0-84'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-142'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-175'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-280'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-51'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-167'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-274'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-156'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-154'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-147'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode ='1-277'
|
||
update Comprehensive_InspectionEquipment set RemarkCode = null where RemarkCode like '%-%'
|
||
go
|
||
|
||
alter table Comprehensive_InspectionEquipment alter column RemarkCode int
|
||
go
|
||
alter table Comprehensive_InspectionPerson alter column RemarkCode int
|
||
go
|
||
alter table Comprehensive_InspectionMachine alter column RemarkCode int
|
||
go
|
||
alter table Comprehensive_TrainingRecords alter column RemarkCode int
|
||
go
|
||
alter table Comprehensive_ConTechnologyDisclosure alter column RemarkCode int
|
||
go |