Thursday, July 7, 2016

Access NZ() function to SQL Server equivalent


What is the SQL Server equivalent to Access NZ() function?


Access SQL
  • NZ([Event Timestamp])


SQL Server Equivalent
  • COALESCE([Event Timestamp],0)
  • ISNULL([Event Timestamp],0)
    • do not confuse this with the Access isnull() function.

No comments: