In addition to the the Commonwealth Ensign, there are three other official Australian ensigns: 1  The Australian Red Ensign - Merchant Navy, as for the Australian flag, but with a red field with white stars. 2  The Australian White Ensign - Royal Australian Navy - as for the Australian flag but with a white field and dark blue stars.
Null (or NULL) is a special marker used in Structured Query Language to indicate that a data value does not exist in the database. Introduced by the creator of the relational database model, E. F. Codd, SQL Null serves to fulfil the requirement that all true relational database management systems (RDBMS) support a representation of missing information and inapplicable information.
The COALESCE and ISNULL T-SQL functions are used to return the first non-null expression among the input arguments. Both are used to handle the NULL value in T-SQL. ISNULL takes two arguments and COALESCE takes more than two arguments as required.