MSSQL CASE example

SELECT

      CASE WHEN EXISTS 

        ( 

            SELECT

                1

            FROM

                sys.tables t

                JOIN sys.columns c on t.object_id = c.object_id

            WHERE

                t.name = 'Articles'

                AND c.is_identity = 1 

        ) THEN 1

        ELSE 0

    END