You can't directly set computed columns based on other column values within the DEFAULT constraint. You can achieve this using computed columns or triggers to generate a dynamic value based on other column values.

Computed Column Method:

CREATE TABLE YourTable (
    ID INT,
    Name NVARCHAR(50),
    Address NVARCHAR(50),
    Remarks AS ('Name: ' + Name + ', Address: ' + Address)
)

INSERT INTO YourTable (ID, Name, Address)
VALUES (1, 'Richard', 'USA'), (2, 'Amit', 'India');

Trigger Method:

CREATE TABLE YourTable (
    ID INT,
    Name NVARCHAR(50),
    Address NVARCHAR(50),
    Remarks NVARCHAR(MAX)
)

CREATE TRIGGER SetRemarks ON YourTable
AFTER INSERT
AS
BEGIN
    UPDATE YourTable
    SET Remarks = 'Name: ' + INSERTED.Name + ', Address: ' + INSERTED.Address
    FROM YourTable
    INNER JOIN INSERTED ON YourTable.ID = INSERTED.ID
END

INSERT INTO YourTable (ID, Name, Address)
VALUES (1, 'Richard', 'USA'), (2, 'Amit', 'India');