SQL Server IF EXISTS THEN 1 ELSE 2

February 2, 2023 by Tarik

If you want to do it this way then this is the syntax you’re after;

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

You don’t strictly need the BEGIN..END statements but it’s probably best to get into that habit from the beginning.