January 18, 2012

Auto Increment of column which is varchar type in sql

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)  
 )