Browse by Tags

All Tags » coalesce()   (RSS)
ISNULL() or COALESCE()?
04 October 07 12:44 PM | Madhivanan | 2 Comments   
Both the functions are used to show/assign different value if the parameter is null. select isnull(null,'test'),coalesce(null,'test') But there are diiferences between the two isnull() is sql server specific The datatype/length of the result depends on Read More...