Here is the DDL. The SQL version is Microsoft SQL Server 2017 (RTM-CU20)

-- DDL and sample data population, start

DECLARE @start TABLE

(ID INT IDENTITY PRIMARY KEY,

data VARCHAR(20) NULL);

INSERT...

well, if you're trying to update the samplecolumn field, you don't list that in your update, you're updating the type_of_column (maybe a problem in your sample data?)

Other than that,...

• This reply was modified 5 years, 5 months ago by Edward Chau.