sp_spaceused (Transact-SQL) SP中涉及哪些表

mark 书签 记url用

https://msdn.microsoft.com/en-us/library/ms188776.aspx

select object_name(id) from syscomments where id in (select id from sysobjects where type ='P') and text like '%Trade%'  （mark， 哪天找二哥问问，是啥意思）

例子：

select distinct object_name(id) from syscomments where id in
(select id from sysobjects where type ='P' ) and text like '%PF%'   查询出名字中有PF的SP，涉及到哪些表名。。。