Click or drag to resize
sqx

ALLVALUES Structure

Aggregate [bit] ALLVALUES([sql_variant] Value)

Namespace:  sqx
Assembly:  SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)
Syntax
C#
[SerializableAttribute]
public struct ALLVALUES
Remarks
All Values NOT NULL aggregate function.
Return 1 when all values are NOT NULL, 0 otherwise.

Attributes

Format.Native, IsInvariantToDuplicates = true, IsInvariantToNulls = false, IsInvariantToOrder = true, IsNullIfEmpty = true
Examples
SQL
DECLARE @Test TABLE (
ID int NOT NULL IDENTITY PRIMARY KEY,
V1 int NULL,
V2 float NULL,
V3 float NULL
)
INSERT @Test (V1, V2, V3)
VALUES (1, 2, 3)
INSERT @Test (V1, V2, V3)
VALUES (2, 3.5, 0.2)
INSERT @Test (V1, V2, V3)
VALUES (4, 1, 2.5)

SELECT sqx.ALLVALUES(V1) & sqx.ALLVALUES(V2) & sqx.ALLVALUES(V3) AS ALLVALUES
FROM @Test
/*
ALLVALUES
-------
1*/

UPDATE @Test SET V2 = NULL WHERE ID = 2

SELECT sqx.ALLVALUES(V1) & sqx.ALLVALUES(V2) & sqx.ALLVALUES(V3) AS ALLVALUES
FROM @Test
/*
ALLVALUES
-------
0*/
See Also