Browse by Tags

All Tags » isnull (RSS)

ISNULL() or COALESCE()?

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...
Posted by Madhivanan | with no comments
Filed under: , ,