How to make member ID

Question

How to make a member ID ? i want to join 0000 id (autoincrement) DateTime.day datetime.years(2) example : Id ={12..} DateTime= {01/08/2015} so i have member ID = {000010115000020115...} if you have solution please teach me thanks

Amitesh Verma · Answer

declare @yearvalue int@Identitydate int@newid varchar(20) select @yearvalue=right(DATEPART(YYGETDATE())2) print @yearvalue select @Identitydate=IDENT_CURRENT('tablename') print @Identitydate set @newid='000'+''+cast(@Identitydate as varchar(5)) +''+cast(@yearvalue as varchar(5)) select @newid