June 01
Pop quiz
What is the output of the following SQL, and why?
IF 'BARRY' = 'BARRY ' BEGIN SELECT 1; END ELSE BEGIN SELECT 0; END IF 'BARRY ' = 'BARRY' BEGIN SELECT 1; END ELSE BEGIN SELECT 0; END IF 'BARRY ' LIKE 'BARRY' BEGIN SELECT 1; END ELSE BEGIN SELECT 0; END IF 'BARRY' LIKE 'BARRY ' BEGIN SELECT 1; END ELSE BEGIN SELECT 0; END