I found this https://www.mssqltips.com/sqlservertip/1467/populate-a-sql-server-column-with-a-sequential-number-not-using-an-identity/ but the problem is that my column is not an int but an nvarchar. Also, I need the column values should be populated with C100001...C10002...
I tried this but I get a conversion error.
DECLARE @id int
SET @id = 10000
SET @id = id = 'C' + CAST(@id as nvarchar(50)) + 1
How can I rewrite this?