here is my query:
CREATE VIEW VIEW2 AS SELECT [Column1], (NULL) AS column2 VARCHAR(10) FROM VIEW1;
I get an error in the third line.
If I leave the query like this, without specifying the data type for Column2, the query works, but the default data type will be int, whereas I want to have VARCHAR.
CREATE VIEW VIEW2 AS SELECT [Column1], (NULL) AS column2 FROM VIEW1;
Can you please help? Thank you!
Note: Only Column1 is in VIEW1. Column2 is NOT in VIEW1, it's a generated column with NULL values.