SQL

LIMIT/OFFSET in MS-SQL:

Use OFFSET /FECTCH – note need to have an ORDER BY clause also to order it

SELECT * FROM table
ORDER BY this_column
OFFSET 25 ROWS
FETCH NEXT 70 ROWS ONLY

WILDCARDS:

• “*” – anything
• “%abcde%” – anything before/anything after
• “a_cd_” – any single character at that location

DROP table if exists:

• SQL 2016+
  • DROP TABLE IF EXISTS table
• Other MS-SQL optoins:
  • https://www.mssqltips.com/sqlservertip/6769/sql-server-drop-table-if-exists/