Hey,
You can concatinate the incremented value with the year, please refer the below snippet and accordingly change the code.
DECLARE @y int
set @y = DateName(yy,getdate())
select cast(ID as varchar(10)) +'/' + cast(@y as varchar(10)) from myTable
Note: Below code is the secondary solution from code level
class Program
{
static void Main(string[] args)
{
int[] serialNumbers = new int[] { 1, 2, 3, 4, 5 };
foreach (var v in serialNumbers)
{
Console.WriteLine("serial number: " + v + " / " + DateTime.Today.Year.ToString());
}
}
}
Output:-
serial number: 1 / 2019
serial number: 2 / 2019
serial number: 3 / 2019
serial number: 4 / 2019
serial number: 5 / 2019