更新字段名包含某些字符的字段为Null

declare @sql varchar(8000)

set @sql = ''

select @sql = @sql + name +' = null,'

from dbo.syscolumns

where id = OBJECT_ID('dbo.EF_ARF_TERMINATION_DETAIL')

and name like 'VERIFY_%'

set @sql = substring(@sql,0,len(@sql))

set @sql = 'update EF_ARF_TERMINATION_DETAIL set ' + @sql +

' where atf_counter = ''WTM01035'''

exec(@sql)