摘要:
SQL学习之查询技巧 查询表是否存在的两种方法方法一 判断系统对象是否存在DECLARE @DbTableFileName VARCHAR(100)SET @DbTableFileName = 'tx'IF objectproperty(object_id(@DbTableFileName),'IsUserTable') IS NOT NULL PRINT 'EXISTS 'ELSE PRINT 'NOT EXISTS 'IF object_id(@DbTableFileName) IS NOT NULL PRINT 'E 阅读全文