Sql 函数笔记

ISNULL

ISNULL ( check_expression , replacement_value )

-----------------------------------------------

REPLICATE

Repeats a string value a specificed number of times

SELECT REPLICATE('0', 6) --000000,

-----------------------------------------------

COALESCE

Returns the first notnull expression among its arguments

    SELECT  COALESCE(NULL,2,1) --2