How to convert numeric to nvarchar in SQL Server?

How to convert numeric to nvarchar in SQL Server?

CREATE TABLE TEST(
  ID INT IDENTITY(1,1) NOT NULL,
  OtherCol INT,
  Name AS CONCAT('Agent_', CAST(ID AS VARCHAR(10))) PE,
  CONSTRAINT PKT PRIMARY KEY(Name)
)

2020-05-05

Tag