Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Computed column with leading static number RE: Computed column with leading static number
Sergiy
SSC Guru
Points: 110206
More actions
June 19, 2016 at 10:05 pm
#1885777
'12345' + replace(STR(ID,9,0), ' ', '0')
_____________Code for TallyGenerator