--触发器不能通过
select 'exec sp_refreshsqlmodule '''+schema_name(schema_id)+'.'+name+''''from sys.objectswhere TYPE in ('FN',/*'TR',*/'IF','TF')
原文链接：https://www.f2er.com/javaschema/287543.html
--触发器不能通过
select 'exec sp_refreshsqlmodule '''+schema_name(schema_id)+'.'+name+''''from sys.objectswhere TYPE in ('FN',/*'TR',*/'IF','TF')
原文链接：https://www.f2er.com/javaschema/287543.html