What is COALESCE and CHECK constraint in SQL server?
- Sharad Jaiswal
- 22nd Feb, 2018
1 answer(s) :
-
Reply
"
SQL Coalesce constraint: It is a function of the SQL server which is used for handling the NULL values. By using this function at the time of evaluation the null values will be replaced by the defined values.
Syntax
COALESCE (expression [ 1…..n])
To use coalesce constraint it is needed that all expressions should be of the same type of data. Multiple expressions are acceptable by this function of SQL.
SQL CHECK constraint: The SQL CHECK constraint is used for specifying the values of the column. It is needed that it satisfies the Boolean expression. The definition of check constraint always comes after the data type along with a keyword CHECK.
Post your Answer :
Valid name is required.
Valid name is required.
Valid email id is required.
Sam Chadwick
17th Feb, 2020