Database

How to puzzle SET ANSI_NULLS and resultset in sqlserver

  SET ANSI_NULLS ON; — Query1 SELECT ‘SQLAuthority’ AS Statement11 WHERE ‘Authority’ IN (‘m’,’y’, ‘c’, ‘tips’, NULL); — Query 2 SELECT ‘SQLAuthority’ AS Statement12 WHERE ‘Authority’ NOT IN (‘S’,’Q’, ‘L’,…