drop table test;
go
create table test (id int identity(0001,1), date datetime);
go
insert into test values (getdate());
go
select convert(char(4),year(date))+convert(char(2),month(date))+convert(char(2),day(date))+convert(varchar(4),id) from test;
go
create view testview (a)
as
select convert(char(4),year(date))+convert(char(2),month(date))+convert(char(2),day(date))+convert(varchar(4),id) as a from test;
go
select * from testview;
go