You are here
Home > Posts tagged "not null"

Handling NULL values in SQL

Handling NULL values in SQL In this post we learn how to handle NULLs in SQL server. for handling NULLs in SQL server we use ISNULL(), NULLIF(), COALESCE() functions with example. ISNULL(): The ISNULL() function is commonly used function that return first value that is not null among their input. Syntax: ISNULL(col_name, replacement_value) The

Learn SQL Part-2

LEARN SQL: PART-2 In this post we will discuss constraints in SQL server. SQL constraints are used to specify rules for storing data in to table. Constraints defined rules that must be applied to data before storing them into database/table to ensure integrity. Only data, which satisfies the conditions will be