Reviewing the Use of Functions :: SQL Server 2012

The same company who hired you to review their use of data types would like you to also review their use of functions. They pose the following question to you:
  1. Our application has worked with SQL Server so far, but due to a recent merger with another company, we need to support other database platforms as well. What can you recommend in terms of use of functions?


  1. To improve the portability of the code, it's important to use standard code when possible, and this of course applies more specifically to the use of built-in functions. For example, use COALESCE and not ISNULL, use CURRENT_TIMESTAMP and not GETDATE, and use CASE and not IIF.