SELECT 'OFNSR' + cast(cast(((100000000-10+1)*RAND()+10) as int) as nvarchar) + '#'
+ cast(right('0'+cast(datepart(day, getdate()) as nvarchar),2) as nvarchar)
+ cast(right('0'+cast(datepart(month, getdate()) as nvarchar),2) as nvarchar)
+ cast(right('0000'+cast(datepart(year, getdate()) as nvarchar),4) as nvarchar)
Время - аналогично