交流，共同进步，成长一点一滴，记录每一个脚印

摘要： 判断 临时表#tmp是否存在if(object_id('tempdb..#tmp') is not null)begindrop table #tmpend1）判断 表DepartmentInfo是否存在if object_id('DepartmentInfo') is null beginselect '不存在'endelsebegin select '存在'end 2）判断表'LC_Department是否存在if not exists (select * from sysobjects where [name] = 阅读全文