SQL Server Null Function and Comment. Session 28
Null Functions
ISNULL ()
ISNULL () function is used to replace NULL values.
Syntax:
SELECT column(s) FROM table_name
WHERE ISNULL(column_name);
NULLIF ()
The NULLIF function takes two arguments. If the two arguments are equal, then NULL is returned. Otherwise, the first argument is returned.
Syntax:
SELECT column(s), NULLIF(expression1, expression2)
FROM table_name;
SELECT col1,col2, IFNULL(col3, value_to_be_replaced) FROM tableName;
Comments
• Single line comment
• Multiline comment.
On this page of the site you can watch the video online SQL Server Null Function and Comment. Session 28 with a duration of hours minute second in good quality, which was uploaded by the user Sunny@Pandita 12 September 2024, share the link with friends and acquaintances, this video has already been watched 75 times on youtube and it was liked by 3 viewers. Enjoy your viewing!
