Search results
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: SELECT NULLIF('Hello', 'Hello'); Try it Yourself » Example. Compare two expressions:
- Try It Yourself
Edit the SQL Statement, and click "Run SQL" to see the...
- The Try-SQLSERVER Editor
Edit the SQL Statement, and click "Run SQL" to see the...
- Try It Yourself
If the two arguments are equal, the NULLIF function returns NULL, otherwise, it returns the first argument. The following illustrates the syntax of the NULLIF function. NULLIF(argument_1,argument_2); Code language: SQL (Structured Query Language) (sql) The NULLIF function is equivalent to the following searched CASE expression:
Transact-SQL syntax conventions. Syntax NULLIF ( expression , expression ) Arguments. expression Is any valid scalar expression. Return Types. Returns the same type as the first expression. NULLIF returns the first expression if the two expressions are not equal. If the expressions are equal, NULLIF returns a null value of the type of the first ...
SQL Server NULLIF expression overview. The NULLIF expression accepts two arguments and returns NULL if two arguments are equal. Otherwise, it returns the first expression. The following shows the syntax of the NULLIF expression: NULLIF(expression1, expression2) Code language: SQL (Structured Query Language) (sql)
Syntax. The syntax for the SQL NULLIF function is as follows: NULLIF(expression1, expression2) expression1: The first expression or value you want to compare. expression2: The second expression or value you want to compare to expression1.
4 wrz 2023 · This cheat sheet is a comprehensive guide to SQL Server, offering a quick reference to its essential commands. It covers the basics of creating and displaying databases and tables, the commands to modify tables, and the fundamental syntax for T-SQL commands such as SELECT, INSERT, UPDATE, and DELETE.
19 maj 2021 · The NULLIF () function accepts the expressions as parameter and returns NULL if both of them are equal. Syntax: NULLIF(expression1, expression2) Parameters Used: expression1 – It is used to specify the first expression. expression2 – It is used to specify the second expression. Return Value:
