如何获取使用特定函数的过程列表 [英] How to get list of Procedures that uses a particular function

问题描述

如何获取使用特定用户定义函数的用户定义过程列表。





谢谢，

Deepak

解决方案

访问链接...

http://blog.strictly-software.com/2009/12/find-text-inside-stored-procedure-or.html [ ^ ]

传递你的functionName在上面的链接存储过程中作为参数搜索

快乐编码！

：）

hi，



检查以下代码

  SELECT   DISTINCT   OBJECT_NAME （ID） FROM  syscomments  WHER E   text   LIKE  ' ％Your_UDF_Name％' 

问候，

GVPrabu

对于初学者......

 SELECT * FROM INFORMATION_SCHEMA.ROUTINES ... 

健壮。 ..如果与表格列等已知信息一起使用会更加健壮：

 SPECIFIC_CATALOG SPECIFIC_SCHEMA SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE MODULE_CATALOG MODULE_SCHEMA MODULE_NAME UDT_CATALOG UDT_SCHEMA UDT_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH COLLATION_CATALOG COLLATION_SCHEMA COLLATION_NAME CHARACTER_SET_CATALOG CHARACTER_SET_SCHEMA CHARACTER_SET_NAME NUMERIC_PRECISION NUMERIC_PRECISION_RADIX NUMERIC_SCALE DATETIME_PRECISION INTERVAL_TYPE INTERVAL_PRECISION TYPE_UDT_CATALOG TYPE_UDT_SCHEMA TY PE_UDT_NAME SCOPE_CATALOG SCOPE_SCHEMA SCOPE_NAME MAXIMUM_CARDINALITY DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS IS_NULL_CALL SQL_PATH SCHEMA_LEVEL_ROUTINE MAX_DYNAMIC_RESULT_SETS IS_USER_DEFINED_CAST IS_IMPLICITLY_INVOCABLE CREATED LAST_ALTERED 
 

How to get list of user defined procedures that uses a particular User defined function.


Thanks,
Deepak

解决方案

Visit link...
http://blog.strictly-software.com/2009/12/find-text-inside-stored-procedure-or.html[^]
pass your functionName to search as parameter in above link store procedure
Happy Coding!
:)

hi,

Check the following Code

SELECT DISTINCT OBJECT_NAME(ID) FROM syscomments WHERE text LIKE '%Your_UDF_Name%'

Regards,
GVPrabu

For starters ...

SELECT * FROM INFORMATION_SCHEMA.ROUTINES ...

Robust ... and more robust if used in conjunction with some known information such as table columns:

SPECIFIC_CATALOG    SPECIFIC_SCHEMA SPECIFIC_NAME   ROUTINE_CATALOG ROUTINE_SCHEMA  ROUTINE_NAME    ROUTINE_TYPE    MODULE_CATALOG  MODULE_SCHEMA   MODULE_NAME UDT_CATALOG UDT_SCHEMA  UDT_NAME    DATA_TYPE   CHARACTER_MAXIMUM_LENGTH    CHARACTER_OCTET_LENGTH  COLLATION_CATALOG   COLLATION_SCHEMA    COLLATION_NAME  CHARACTER_SET_CATALOG   CHARACTER_SET_SCHEMA    CHARACTER_SET_NAME  NUMERIC_PRECISION   NUMERIC_PRECISION_RADIX NUMERIC_SCALE   DATETIME_PRECISION  INTERVAL_TYPE   INTERVAL_PRECISION  TYPE_UDT_CATALOG    TYPE_UDT_SCHEMA TYPE_UDT_NAME   SCOPE_CATALOG   SCOPE_SCHEMA    SCOPE_NAME  MAXIMUM_CARDINALITY DTD_IDENTIFIER  ROUTINE_BODY    ROUTINE_DEFINITION  EXTERNAL_NAME   EXTERNAL_LANGUAGE   PARAMETER_STYLE IS_DETERMINISTIC    SQL_DATA_ACCESS IS_NULL_CALL    SQL_PATH    SCHEMA_LEVEL_ROUTINE    MAX_DYNAMIC_RESULT_SETS IS_USER_DEFINED_CAST    IS_IMPLICITLY_INVOCABLE CREATED LAST_ALTERED

这篇关于如何获取使用特定函数的过程列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！