hello I have one questiom im new to SQL dbs...
I need to generate ID in one table in this format
YYYYMMDDXXX
where YYYYMMDD is date of day and XXX is uniqe number raising by 1 .
and every day XXX starts from 000
I need to generate ID in one table in this format
YYYYMMDDXXX
where YYYYMMDD is date of day and XXX is uniqe number raising by 1 .
and every day XXX starts from 000
Comment