sql server 判断数据库表是否存在
1:判断正常表 select count(*) from SysObjects where XType='U' and name ='table'
2:判断临时表 if exists(select * from tempdb..sysobjects where id=object_id('tempdb..#temp1'))
2:判断临时表 if exists(select * from tempdb..sysobjects where id=object_id('tempdb..#temp1'))