if object_id('tempdb..abc') is not null
print 'exists'
if object_id('tempdb..sp_abc') is not null
print 'exists'
print 'exists'
if object_id('tempdb..sp_abc') is not null
print 'exists'
调试欢乐多
select * from sysobjects where xtype='U' and name='abc'
select * from sysobjects where xtype='P' and name='sp_abc'