Guidcomparison in .net and sql server

you will not get what you expect when comparing the same guids in .net and the sqlserver :-(

TL;DR;
sqlserver and .net obviously compare guids diffrently

Recently i had to implement something, which required the comparison of guids. I wondered, whether the comparison of guids is the same in the .net framework and the sql server.
It wasn’t clear to me from the documentation so i tried in c# interactive and pasted the sql command in a sql server session and got diffrent answers from .net and the sql server :-(

sqlserver said:

from the command generated via:

,

No comments yet.

Leave a Reply