Yahoo Poland Wyszukiwanie w Internecie

Zaloguj się

Search results

  1. www.w3schools.com › Sql › func_sqlserver_nullifSQL Server NULLIF() Function - W3Schools

    Example. Compare two expressions: SELECT NULLIF(25, 25); Try it Yourself » Definition and Usage. The NULLIF () function returns NULL if two expressions are equal, otherwise it returns the first expression. Syntax. NULLIF (expr1, expr2) Parameter Values. Technical Details. More Examples. Example. Compare two expressions:

  2. learn.microsoft.com › en-us › sqlNULLIF (Transact-SQL) - SQL Server | Microsoft Learn

    Returns a null value if the two specified expressions are equal. For example, SELECT NULLIF(4,4) AS Same, NULLIF(5,7) AS Different; returns NULL for the first column (4 and 4) because the two input values are the same.

  3. www.sqltutorial.org › sql-comparison-functions › sql-nullifSQL NULLIF Function: Usage of a Handy SQL Control Flow ... - SQL...

    SQL NULLIF examples. The following statement returns NULL because 100 is equal to 100. SELECT NULLIF (100, 100); Code language: SQL (Structured Query Language) (sql) The following statement returns 100 because 100 is less than 200, the NULLIF function returns the first argument which is 100.

  4. www.sqlservertutorial.net › sql-server-basics › sql-server-nullifSQL Server NULLIF

    SQL Server NULLIF examples. Let’s take some examples of using the NULLIF expression. Using NULLIF expression with numeric data examples. This example returns NULL because the first argument equals the second one: SELECT NULLIF (10, 10) result; Code language: SQL (Structured Query Language) (sql) Here is the output:

  5. sqlskull.com › 2021/01/15 › sql-nullifSQL NULLIF - SQL Skull

    15 sty 2021 · SQL NULLIF expression compares two expression and returns a null value if the two specified expressions are equal, else it returns the first expression. NULLIF expression is equivalent to a searched CASE expression in which the two expressions are equal and the resulting expression is NULL.

  6. hightouch.com › sql-dictionary › sql-nullifSQL NULLIF - Syntax, Use Cases, and Examples | Hightouch

    The SQL NULLIF function is used to compare two expressions or values and return NULL if they are equal. It provides a way to handle specific cases where you want to treat equality as a special condition by substituting it with a NULL value.

  7. www.techonthenet.com › sql_server › functionsSQL Server: NULLIF Function - TechOnTheNet

    Let's look at some SQL Server NULLIF function examples and explore how to use the NULLIF function in SQL Server (Transact-SQL). For example: SELECT NULLIF('TechOnTheNet.com', 'TechOnTheNet.com'); Result: NULL (returns NULL because values are the same) SELECT NULLIF('CheckYourMath.com', 'TechOnTheNet.com'); Result: 'CheckYourMath.com' (returns ...