1、查看所有存储过程与函数
exec sp_stored_procedures
或者
select * from dbo.sysobjects where OBJECTPROPERTY(id, N'IsProcedure') = 1 order by name
2、查看存储过程的内容
select text from syscomments where id=object_id('存储过程名称')
1、查看所有存储过程与函数
exec sp_stored_procedures
或者
select * from dbo.sysobjects where OBJECTPROPERTY(id, N'IsProcedure') = 1 order by name
2、查看存储过程的内容
select text from syscomments where id=object_id('存储过程名称')