SQL Server2008R2学习记录
时间:2022-03-15 18:26
判断存在
1,判断表存在字段(参考:)
IF EXISTS(SELECT 1 FROM SYSOBJECTS so,SYSCOLUMNS sc WHERE so.ID = sc.ID AND so.NAME=‘表名‘ AND sc.NAME=‘字段‘)
IF EXISTS(SELECT 1 FROM syscolumns WHERE id = object_id(‘表名‘) AND name = ‘字段‘)
IF COL_LENGTH(‘表名‘, ‘字段‘) IS NOT NULL PRINT N‘存在‘ ELSE PRINT N‘不存在‘