Hugo Kornelis (10/30/2015)

---

I like the question. Good reminder of the intricacies of working with views.

There is a small mistake in the explanation, though. Changing data types will not cause conversion errors in the select statement. Repro (and watch the column name!):

CREATE TABLE dbo.t1

(DateCol date NOT NULL);

INSERT INTO dbo.t1 VALUES (CURRENT_TIMESTAMP);

GO

CREATE VIEW dbo.v1

AS SELECT * FROM dbo.t1;

GO

SELECT * FROM dbo.v1;

DROP TABLE dbo.t1;

CREATE TABLE dbo.t1 (CharCol varchar(20));

INSERT INTO dbo.t1 VALUES ('I am not a datetime');

SELECT *

FROM dbo.v1;

DROP VIEW dbo.v1;

DROP TABLE dbo.t1;