Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the breadcrumb-navxt domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/devtools/public_html/blog/wp-includes/functions.php on line 6131
{"id":455,"date":"2013-06-18T20:28:00","date_gmt":"2013-06-18T23:28:00","guid":{"rendered":"https:\/\/devtools.com.br\/blog\/ifnull-no-sql-server-isnull\/"},"modified":"2022-08-01T08:03:52","modified_gmt":"2022-08-01T11:03:52","slug":"ifnull-no-sql-server-isnull","status":"publish","type":"post","link":"https:\/\/devtools.com.br\/blog\/ifnull-no-sql-server-isnull\/","title":{"rendered":"IFNULL no SQL Server: ISNULL"},"content":{"rendered":"\n

A ocorr\u00eancia de valores nulos em banco de dados \u00e9 algo normal, por\u00e9m, o tratamento do retorno destes `valores` \u00e9 algo muito importante. O padr\u00e3o SQL ANSI  nos disponibiliza para este tratamento a fun\u00e7\u00e3o Coalesce, que \u00e9 encontrada na maiores dos bancos de dados existentes, por\u00e9m, normalmente cada empresa propriet\u00e1ria de SGBD’s implementa suas pr\u00f3prias fun\u00e7\u00f5es, como \u00e9 o caso da Microsoft, com o uso do ISNULL, da Oracle, com o NVL e etc.<\/p>\n\n\n\n

J\u00e1 abordei aqui no blog como trabalhar com valores nulos no PostgreSQL:<\/p>\n\n\n\n