MS SQL if exists code example

Example 1: if exists sql server

IF EXISTS (SELECT * FROM tblGLUserAccess WHERE GLUserName ='xxxxxxxx') 
BEGIN
   SELECT 1 
END
ELSE
BEGIN
    SELECT 2
END

Example 2: sql if exists

if exists(select 1 from table where id = 4)