Pastebin

SELECT 42;
SELECT 2+2;
SELECT * FROM foo;
SELECT * FROM foo WHERE 1 = 1;
SELECT * FROM foo WHERE 1 = 1 AND 2 = 2;
SELECT * FROM foo WHERE 1 = 1 AND 2 = 2 OR 3 = 4;
SELECT * FROM foo WHERE id > 7 OR id < 10;
SELECT * FROM foo ORDER BY id DESC;
SELECT * FROM foo ORDER BY id ASC;
SELECT * FROM foo ORDER BY newid();
SELECT * FROM foo F, bar B WHERE F.id = b.id;
SELECT TOP 5 * FROM foo;
SELECT TOP 5 id FROM foo;
SELECT TOP 5 id, f1 FROM foo;
SELECT COUNT(*) FROM foo;
SELECT COUNT(id) AS num FROM foo;
SELECT TOP 5 id FROM [foo];
SELECT AVG(id) FROM foo;
SELECT TOP 1 42 FROM [foo] WHERE DAY(42) = DAY(32);
SELECT TOP 5 id FROM foo WHERE f3 LIKE '%foo%';

SELECT TOP 5 col1, col2, col3 FROM table1;
SELECT * FROM table1;

SELECT col1, col2, col3 INTO table2 FROM table1;
SELECT * INTO table1_copy FROM table1;
SELECT col1 INTO table1_copy2(col1) FROM table1;

SELECT DISTINCT f2 FROM foo;

SELECT id FROM foo WHERE f3 <> 'foo';

SELECT id FROM foo WHERE f4 > '1/1/2000';
SELECT id FROM foo WHERE f4 >= '1/1/2000';
SELECT id FROM foo WHERE f4 < '1/1/2000';
SELECT id FROM foo WHERE f4 <= '1/1/2000';
SELECT id FROM foo WHERE f3 LIKE '117%';
SELECT id FROM foo WHERE f3 LIKE '117%foo';
SELECT id FROM foo WHERE f3 LIKE '%foo';
SELECT id FROM foo WHERE f4 BETWEEN '1/1/2000' AND '2/2/2000';
SELECT id FROM foo WHERE f3 LIKE '[4-6]_6%'; 

INSERT INTO table3 VALUES(42, 'value1', 'value2', 'value3');
INSERT INTO table3(id, f1, f2, f3) VALUES(117, 'foo', 'bar', 'baz');

UPDATE table1 SET f3 = 'foo' WHERE id = 117;

DELETE FROM table1 WHERE id = 117;
DELETE FROM table4;

SELECT id, f4 FROM foo ORDER BY f4;
SELECT id, f4 FROM foo ORDER BY f4 ASC;
SELECT id, f4 FROM foo ORDER BY f4 DESC;
SELECT id, f4 FROM foo ORDER BY f4, id;
SELECT id, f4 FROM foo ORDER BY f4, id ASC;
SELECT id, f4 FROM foo ORDER BY f4 ASC, id DESC;

SELECT id FROM foo WHERE id = 117 OR id = 42;
SELECT id FROM foo WHERE id = 117 AND f6 = 1;
SELECT id FROM foo WHERE (id = 56 OR id > 100) AND f3 LIKE '%foo%';

SELECT id FROM foo WHERE id IN(1, 2, 3, 117);

SELECT f7, SUM(f8) AS f8sum FROM foo GROUP BY f7;

SELECT aliasedFoo.f7 FROM foo AS aliasedFoo;

SELECT COUNT(id) FROM foo;
SELECT COUNT(*) AS num FROM foo;
SELECT MAX(f7) FROM foo;
SELECT MIN(f7) FROM foo;
SELECT AVG(f7) FROM foo;
SELECT SUM(f7) FROM foo;

SELECT foo.f10, SUM(f11) FROM foo GROUP BY f10 HAVING SUM(f11) > 42;
SELECT foo.f10, SUM(f11) AS f11sum FROM foo, table5 WHERE foo.id = table5.fooid GROUP BY foo.f10;
SELECT foo.f10, SUM(f11) AS f11sum FROM foo JOIN table5 ON foo.id = table5.fooid GROUP BY foo.f10;
SELECT foo.f10, SUM(f11) AS f11sum FROM foo LEFT JOIN table5 ON foo.id = table5.fooid GROUP BY foo.f10;
SELECT foo.f10, SUM(f11) AS f11sum FROM foo LEFT OUTER JOIN table5 ON foo.id = table5.fooid GROUP BY foo.f10;
SELECT foo.f10, SUM(f11) AS f11sum FROM foo RIGHT JOIN table5 ON foo.id = table5.fooid GROUP BY foo.f10;
SELECT foo.f10, SUM(f11) AS f11sum FROM foo RIGHT OUTER JOIN table5 ON foo.id = table5.fooid GROUP BY foo.f10;
SELECT foo.f10 FROM foo INNER JOIN table5 ON foo.id = table5.fooid WHERE foo.f12 = 'bar' AND table5.f2 = 'test';


SELECT 42 UNION SELECT 43;
SELECT 2+2 UNION SELECT 2+2;
SELECT 2+2 UNION ALL SELECT 2+2;

SELECT id FROM foo UNION SELECT id FROM bar;

SELECT * FROM foo WHERE id IN (SELECT TOP 10 id FROM bar);


SELECT id, name, city, country FROM person WHERE city IS NOT NULL ORDER BY CASE country WHEN 'United States' THEN city ELSE country END;

SELECT YEAR(datecolumn) FROM datetable;
SELECT DATEPART(yy, datecolumn)  FROM datetable;
SELECT DATEADD(YEAR,1, '2004-2-29');

--SELECT foo.f15;
--SELECT foo.*;
SELECT hest = f15 FROM foo;

--SELECT id, SUBSTRING(name, 1, 5), CAST(age AS char(1)) AS 'age' FROM person ;

SELECT ALL f15 FROM foo;

SELECT 2+2*2;

INSERT INTO table6(f1) DEFAULT VALUES;
INSERT INTO table6 VALUES(42);

SELECT * FROM table7 WHERE f1 NOT LIKE '%foo';


SELECT (8*8)/8;
SELECT 117 % 2;


-- this is a comment;
SELECT 42; -- this is a comment;

SELECT [f1] FROM [foo];
SELECT [f1], [f2] AS foo2 FROM [foo];