Export (0) Print
Expand All

Is

SQL Server 2000

Is

Returns TRUE if two compared objects are equivalent, FALSE otherwise.

Syntax

«Object 1» IS «Object 2»

Returns TRUE if the two tuples or members specified in «Object 1» and «Object 2» are equivalent, FALSE otherwise.

Alternate Syntax

«Object 1» IS NULL

Returns TRUE if the level, tuple, or member specified in «Object 1» is NULL, FALSE otherwise.

Remarks

The Is function is typically used for tuples and members to determine whether the objects are idempotent.

Example

The following example returns FALSE:

Time.[1996] IS NULL
Show:
© 2015 Microsoft