DECLARE @A VARCHAR(10)
DECLARE @B VARCHAR(10)
DECLARE @C VARCHAR(10)
BEGIN
--Step:1
SELECT ISNULL(@A , ' ') -- RETURNS ' '
SELECT ISNULL(@A , NULL) -- RETURNS NULL
SELECT ISNULL(@A , @B) -- RETURNS NULL
--Step:2
SET @A = '' --Since we have assigned some value which is not null
SELECT ISNULL(@A , ' ') -- RETURNS ''
SELECT ISNULL(@A , NULL) -- RETURNS ''
SELECT ISNULL(@A , @B) -- RETURNS ''
--Step:3
SET @A = NULL--Which is same as the Step:1
SELECT ISNULL(@A , ' ') -- RETURNS ''
SELECT ISNULL(@A , NULL) -- RETURNS NULL
SELECT ISNULL(@A , @B) -- RETURNS NULL
--Step:4
SET @B = ' '
SELECT ISNULL(@B , ' ') -- RETURNS ' '
SELECT ISNULL(@B , NULL) -- RETURNS ' '
SELECT ISNULL(@B , @C) -- RETURNS ' '
SELECT ISNULL(@C , @B) -- RETURNS ' '
SELECT ISNULL(@B , @A) -- RETURNS ' '
--Step:5
SET @A = '1'
SELECT ISNULL(@B , @A) -- RETURNS ' '
SELECT ISNULL(@A , @B) -- RETURNS 1
SELECT ISNULL(@C , @A) -- RETURNS 1
END
Thursday, November 6, 2008
Difference between NULL and (Empty or ' ')
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment