判断为NULL
MS: ISNULL(field , 0)
MY: COALESCE(field,0)
当前时间
MS : GETDATE()
MY: NOW() CURDATE()
包含字符串
MS: CHARINDEX(field,'find',0 /*start from*/)
MY :LOCATE(field,'find',0/*start from*/)
待续...
判断为NULL
MS: ISNULL(field , 0)
MY: COALESCE(field,0)
当前时间
MS : GETDATE()
MY: NOW() CURDATE()
包含字符串
MS: CHARINDEX(field,'find',0 /*start from*/)
MY :LOCATE(field,'find',0/*start from*/)
待续...