Auto Increment of column which is varchar type in sql

Axapta Code solutions   Earn Money its Real


Set Auto Increment of column which is varchar type in sql

If you want to Set Auto Increment of column which is varchar type in sql table then you can do that by using following way

CREATE TABLE StudentTable
(
Regid int IDENTITY(1,1) NOT NULL
, StudentCol nvarchar(3) DEFAULT 'STD'
, StudentId AS (StudentCol+ REPLICATE('0', 10-LEN(CONVERT(nvarchar(100),Regid ))
,OtherColumnsYouNeed nvarchar(MAX)
)