In SQL Server both the set and equality functions are handled by the equals sign (=).
However, in some other languages that’s not how it works. In PowerShell for example the equals sign is always a set operation.
Click through to learn the difference, as well as what Powershell uses for equality operations. I think my favorite language for this is Scala, where I jokingly say
= means “is equal to,”
== means “is really equal to,” and
=== means “is equal to and I totally mean it.”