as and is in C#

These keywords are used in scenarios where there is compatible type conversion or we need to check for type compatibility.

Collate in SQL Server

Collate specifies the set of rules that are used during various comparisons, sorting etc. For example it specifies whether the comparisons should be case sensitive or not etc.