sql 查詢存儲過程的定義過程

查詢所有存儲過程：select * from sysobject where type='p';

根據名字查詢存儲過程：select * from sysobject where type='p' and name='過程名';

查詢定義過程：

SELECT definition FROM sys.sql_modules WHERE object_id =(select id from sysobjects where type='p' and name='過程名');