Shane O’Neill has a bandolier of SQL tricks to show off:
Recently the DBA Team Lead and I were reviewing some SQL code, and we came across some SQL that neither of us had frequently encountered before. This led to a brief watercooler moment where we shared some uncommon SQL that we had seen. Perfect blog post material, I think.
I had previously learned about ODBC date functions from Shane and also learned about CURRENT in this post, so check it out.