MSSQL 查询所有用户自定义存储过程和自定义函数
MSSQL 查询所有用户自定义存储过程和自定义函数SQL Code:
--查找所有用户自定义存储过程
select b.name,b.xtype FROM CSFrameworkV5_Normal.dbo.syscomments a, CSFrameworkV5_Normal.dbo.sysobjects b
where a.id=b.id and b.xtype IN ('p') AND name LIKE '%sp\_%' ESCAPE '\'
order by b.xtype,b.name
--查找所有用户自定义函数
select b.name,b.xtype FROM CSFrameworkV5_Normal.dbo.syscomments a, CSFrameworkV5_Normal.dbo.sysobjects b
where a.id=b.id and b.xtype IN ('fn','tf') --AND name LIKE '%fn\_%' ESCAPE '\'
order by b.xtype,b.name
//来源:C/S框架网 | www.csframework.com | QQ:23404761
select b.name,b.xtype FROM CSFrameworkV5_Normal.dbo.syscomments a, CSFrameworkV5_Normal.dbo.sysobjects b
where a.id=b.id and b.xtype IN ('p') AND name LIKE '%sp\_%' ESCAPE '\'
order by b.xtype,b.name
--查找所有用户自定义函数
select b.name,b.xtype FROM CSFrameworkV5_Normal.dbo.syscomments a, CSFrameworkV5_Normal.dbo.sysobjects b
where a.id=b.id and b.xtype IN ('fn','tf') --AND name LIKE '%fn\_%' ESCAPE '\'
order by b.xtype,b.name
//来源:C/S框架网 | www.csframework.com | QQ:23404761
扫一扫加微信
版权声明：本文为开发框架文库发布内容,转载请附上原文出处连接
NewDoc C/S框架网
