» » CHECKSUM and OPTION(RECOMPILE)

CHECKSUM and OPTION(RECOMPILE)

Edit

Working with CHECKSUM
functions, I encountered a situation
when the result of the
CHECKSUM function is
effected by OPTION(RECOMPILE)


Please see following example:




DECLARE @a VARCHAR(5),@b VARCHAR(5)
SET @a='a'
SET @b='b'

SELECT CHECKSUM(@a,@b) as Result






SELECT CHECKSUM(@b,@a) as Result

 



SELECT CHECKSUM(@a,@b) as Result
OPTION(RECOMPILE)




As you can see the result of CHECKSUM(@a,@b) without recompile
and with recompile is different, when using option(recompile)
we see that SQL Server change the order of the variables.

Do you know why?
If yes, Please leave comments.