SELECT OBJECT_NAME(object_id)
FROM sys.sql_modules
WHERE Definition LIKE '%范维肖%'
AND OBJECTPROPERTY(object_id, 'IsProcedure') = 1
SQL Server 2005下测试
SELECT OBJECT_NAME(object_id)
FROM sys.sql_modules
WHERE Definition LIKE '%范维肖%'
AND OBJECTPROPERTY(object_id, 'IsProcedure') = 1
SQL Server 2005下测试
转载于:https://www.cnblogs.com/fanweixiao/archive/2008/09/26/1299291.html