只需检查 INFORMATION_SCHEMA.ROUTINES 表中的 ROUTINE_DEFINITION 字段

Just examine ROUTINE_DEFINITION field in INFORMATION_SCHEMA.ROUTINES table

SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES 
where (LEN(ROUTINE_DEFINITION) - 
       LEN(REPLACE(ROUTINE_DEFINITION, 'JOIN', ''))) / LEN('JOIN')>=7