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:
- 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?
Answers
- 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.