学步园

if object_id('proc1','p') is not null 则proc1存在

if exists (select 1 from sysobject where name='proc1' and xtype='p')