![]() | ALLVALUES Structure |
Namespace: sqx
[SerializableAttribute] public struct ALLVALUES
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*/