Software Vendor Mistakes With SQL Server: Using Functions In Join Or Where Clauses

Easy Thinking

To start with, let’s classify functions into two varietals:

  • Ones built-in to SQL Server
  • Ones that developers write

Of those, built-in functions are pretty much harmless when they’re in the select list. Classifying things a bit further for …