TIL...
> CHECKSUM ignores the nchar and nvarchar dash character (N'-' or nchar(45)).
Therefore, a hash collision is guaranteed for any two strings where the only
differences are dashes.
> ...
> 2. A checksum comparison cannot detect that code was commented-out in stored
proc definition
https://dbfiddle.uk/?rdbms=sqlserver_2019&fiddle=6530da70816f096c303c127d1a8ff720