sql server判定ライブラリ、テーブル、フィールドは存在しません
806 ワード
IF EXISTS(SELECT * FROM sysobjects WHERE name='bbsUser')
PRINT ' '
ELSE
PRINT ' ' --
if EXISTS(SELECT * FROM sys.sysdatabases WHERE name='bbsDB')
PRINT ' '
ELSE
PRINT ' ' --
IF EXISTS (SELECT 1 FROM SYSOBJECTS T1 INNER JOIN SYSCOLUMNS T2 ON T1.ID=T2.ID WHERE T1.NAME='A' AND T2.NAME='C' )
PRINT ' '
ELSE
PRINT ' ' -- A C
IF COL_LENGTH('A', 'C') IS NOT NULL
PRINT N' '
ELSE
PRINT N' ' -- A C
IF NOT EXISTS ( SELECT * FROM table WHERE Bh='A')
begin
print ' '
end -- table Bh='A'