19.查询存储过程包含.sql

SELECT 
    obj.Name ¹ý³ÌÃû,
    sc.TEXT ÄÚÈÝ,
    obj.[type],
    LEN(sc.TEXT)
FROM
    syscomments sc
INNER JOIN sysobjects obj ON sc.Id = obj.ID
WHERE
    sc.TEXT LIKE '%192.168%' AND LEN(sc.[text])>=4000
ORDER BY obj.[type]