When executing the following code in SQL Server SQLExpress 15.0.2110 I get an error telling me that the insert fails due to SQL Server’s inablity to cast my NChar string into an int, where the problem is actually I’m trying to insert an integer into a nvarchar column. Is this fixed in a later version of SQL Server?

GO
IF OBJECT_ID(‘odd_table’) IS NOT NULL
DROP TABLE odd_table

GO
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.DOMAINS isd WHERE isd.Domain_Name = N’odd_table_type’)
drop TYPE odd_table_type

GO
CREATE TABLE odd_table (
[an_nvarchar_column] nvarchar NULL
)
GO
CREATE TYPE odd_table_type AS TABLE (
[an_nvarchar_column] nvarchar NULL
)

GO

INSERT INTO odd_table (an_nvarchar_column) VALUES
    (N'Abracadabra'),
    (3)
;

— Gives the error
/*
Msg 245, Level 16, State 1, Line 20
Conversion failed when converting the nvarchar value ‘Abracadabra’ to data type int.
*/
DECLARE @odd_table_var odd_table_type

INSERT INTO @odd_table_var (an_nvarchar_column) VALUES
    (N'Abracadabra'),
    (3)
;

— Gives the error
/*
Msg 245, Level 16, State 1, Line 34
Conversion failed when converting the nvarchar value ‘Abracadabra’ to data type int.
*/

I have also tried this inserting into a view and within a stored procedure, with the same result.