Assuming that you have an autoincrement field, then it's just a case of selecting the info you want:
SELECT RIGHT('00'+ CONVERT(VARCHAR,DATEPART(month, MyDate)),2) + '-' + RIGHT(CONVERT(VARCHAR,DATEPART(YEAR, MyDate)),2) + '/' + RIGHT('00'+ CONVERT(VARCHAR,Id),2) As Code from MyTable