TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Compares two expressions. When you compare nonnull expressions by using this operator, the result is TRUE when both operands are equal. Otherwise, the result is FALSE.


expression = expression

expression

Any valid expression in Microsoft SQL Server Compact. Both expressions must have implicitly convertible data types. The conversion depends on the rules of data type precedence.

The following example uses the equals comparison operator to select a specific customer in the Orders table.

SELECT * FROM Orders WHERE CustomerID = 'VINET'
Show:
© 2016 Microsoft