chadhutchins · February 10, 2016 14:43
diff --git a/queries1.sql b/queries1.sql
 -- works in MySQL, fails in MSSQL
 SELECT * FROM contacts WHERE title=’CEO’ && title=’CTO’; 

 -- works in both MySQL and MSSQL
 SELECT * FROM contacts WHERE title=’CEO’ AND title=’CTO’;
	-- works in MySQL, fails in MSSQL
	SELECT * FROM contacts WHERE title=’CEO’ && title=’CTO’;

	-- works in both MySQL and MSSQL
	SELECT * FROM contacts WHERE title=’CEO’ AND title=’CTO’;