sql - IF EXISTS, THEN SELECT ELSE INSERT AND THEN SELECT - Stack Overflow

How do you say the following in Microsoft SQL Server 2005: IF EXISTS (SELECT * FROM Table WHERE FieldValue='') THEN SELECT TableID FROM Table WHERE FieldValue='' ELSE INSERT INTO TABLE(Field...

stackoverflow.com