Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Microsoft SQL Server Compact supports operators.
Using Operators
SQL Server Compact supports the following operators.
Arithmetic Operators
+ (Add) |
/ (Divide) |
- (Subtract) |
% (Modulo) |
* (Multiply) |
|
Bitwise Operators
& (AND) |
^ (Exclusive OR) |
| (OR) |
~ (NOT) |
Only one expression can be of either binary or varbinary data type in a bitwise operation.
Comparison Operators
= (Equals) |
<> (Not Equal To) |
> (Greater Than) |
!= (Not Equal To) |
< (Less Than) |
!< (Not Less Than) |
>= (Greater Than or Equal To) |
!> (Not Greater Than) |
<= (Less Than or Equal To) |
|
Logical Operators
ALL |
IN |
AND |
LIKE |
ANY |
NOT |
BETWEEN |
OR |
EXISTS |
SOME |
Unary Operators
+ (Positive) |
- (Negative) |