业务场景:搜索包含关键字的SQL语句
脚本:
SELECT DISTINCT A.ID,B.name,B.type,B.type_desc,B.create_date,
B.modify_date FROM syscomments A
JOIN sys.objects B ON A.id=B.object_id
AND B.type IN('P','V','TF','FN')
WHERE A.text LIKE '%tablename%'
结果:
业务场景:搜索包含关键字的SQL语句
脚本:
SELECT DISTINCT A.ID,B.name,B.type,B.type_desc,B.create_date,
B.modify_date FROM syscomments A
JOIN sys.objects B ON A.id=B.object_id
AND B.type IN('P','V','TF','FN')
WHERE A.text LIKE '%tablename%'
结果: