LISTING 1: T-SQL Script to Create a View of Non-NULL Values 

CREATE TABLE multinulls (
  a int NULL,
  b char(5) default 'hello'
)

GO
CREATE VIEW v_multinulls
WITH SCHEMABINDING
AS
SELECT a FROM dbo.multinulls
WHERE a IS NOT NULL
GO

CREATE UNIQUE CLUSTERED INDEX idx1 ON v_multinulls(a)
GO

INSERT INTO multinulls(a) VALUES(1)

-- Generates error because of duplicate!
INSERT INTO multinulls(a) VALUES(1)

INSERT INTO multinulls(a) VALUES(2)
INSERT INTO multinulls(a) VALUES(3)
INSERT INTO multinulls(a) VALUES(NULL)

-- No error
INSERT INTO multinulls(a) VALUES(NULL)

-- No error
INSERT INTO multinulls(a) VALUES(NULL)
GO

SELECT a, b FROM multinulls
GO

DROP VIEW v_multinulls
DROP TABLE multinulls
GO