NULL Operations in SQL Server

 

 

Using Coalesce()

When we have multi-value attribute with single or more null values in a Table, the Coalesce() function is very useful.

 

 

 

 

ISNULL

Replaces NULL with the specified replacement value.

 

 

 

 

 

 

 

Blogger Labels: NULL,Operations,Server,Coalesce,Table,ISNULL,Replaces