DECLARE @d SMALLDATETIME
SELECT ISNULL(@d,'')
--------------------------------------
结果:1900-01-01 00:00:00
---------------------------------
我希望是:当@d为NULL时,显示为零长度的字符串,如何做?
------解决思路----------------------
DECLARE @d SMALLDATETIME
SELECT ISNULL(CONVERT(VARCHAR(10),@d,120),'')