SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Result(i int)
declare @i int;
exec @i = sp_executesql N'SELECT TOP 1 convert(int, name) FROM sys.columns'
INSERT Result VALUES(@i);
Msg 245 Level 16 State 1 Line 1
Conversion failed when converting the nvarchar value 'i' to data type int.

SELECT * FROM Result


i