>--- Check if the field exists > >IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS > WHERE Column_Name = 'NameOfTheField' > AND Table_Name = 'YourTable') > SELECT CAST(1 AS bit) AS Exists >ELSE > SELECT CAST(0 AS bit) AS Exists >>
>--- Check if SP exists > >IF EXISTS(SELECT * FROM sysobjects > WHERE Name = 'YourSPName' > AND xType = 'P' > SELECT CAST(1 AS bit) AS Exists >ELSE > SELECT CAST(0 AS bit) AS Exists >Hi Boris,
select cast(case when exists(select 1 from ...) then 1 else 0 end as bit) as FieldExists