--得到所有存储过程的名字
select name from sysobjects where xtype='p'

------解决方案--------------------
SQL code

use Test_DB
if exists(select top 1 * from sysobjects where xtype='p' and name='cunchu1')
exec sp_helptext 'cunchu1'