sql 存储过程查看

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('存储过程名称')