1.查询特殊表达式所在的存储过程:
select * from sys.sql_modules where definition like '%1900017%' and object_id in (select object_id from sys.objects where type='P')
2.查询一个表被哪些存储过程使用:
exec sp_depends 'ffunit'
3.通过表找找字段:
select name as 'Column_name' from syscolumns where id
= (select id from sysobjects where id = object_id('')) order by colid
4.通过字段查找表:
select * from sysobjects where id in
(select ID from syscolumns WHERE name ='machineid')