从存储的proc定义中提取字符串

尝试

SELECt     name,     table_name = CASE WHEN OBJECT_DEFINITION(OBJECT_ID) LIKE '%BOCTEST.S653C36C.LIVEBOC_A.YP040P%' THEN 'LIVEBOC_A'WHEN OBJECT_DEFINITION(OBJECT_ID) LIKE '%BOCTEST.S653C36C.LIVEBOC_B.YP040P%' THEN 'LIVEBOC_B' ENDFROM sys.objects oWHERe o.[type] IN ('P', 'PC')AND name like '%_Extract'