结论:isnull返回字符串大小,取决于isnull判断对象的大小;
如:isnull(table.col1,'null'),这里的返回字符串大小取决于col1的大小;
实验:
DECLARE @test TABLE (
col1 VARCHAR(1)
)
INSERT INTO @test
SELECT 'a'
UNION
SELECT NULL
UNION
SELECT 'b'
SELECT *
FROM @test
SELECT ISNULL(a.col1,'null')
FROM @test AS a
结果: