2012情人节
February 19, 2012 Views
Comments 0
【SQL】查询用到了某个表或某段语句的所有存储过程
October 21, 2011 Views
Comments 0
折叠SQL Code复制内容到剪贴板
- select distinct object_name(id) from syscomments
- where id in (select object_id from sys.objects where type ='P') --SQL2005及以上版本写法
- --type = 'P'代表要查询的是 存储过程
- --where id in (select id from sysobjects where type ='P') --SQL2000写法
- and text like '%tablename%'
阅读全文知识库
【SQL】unable to load the requested database interface. pleas make sure both the int 解决方案
September 26, 2011 Views
Comments 0
