表:
if exists(select * from sysobjects where id=object_id('tablename') and xtype='U)'
print 'table exist'临时表:
if object_id('tempdb..temptablename') is not null
print 'temptable exist'
if exists(select * from sysobjects where id=object_id('tablename') and xtype='U)'
print 'table exist'临时表:
if object_id('tempdb..temptablename') is not null
print 'temptable exist'
print 'yes'
else
print 'no'