sql合并字段

create table Test(id int primary key identity(1,1),[FillYear] int,[FillMonth] int,[FillDay] int)select * from Test;insert into Test(FillYear,FillMonth,FillDay) values(2014,9,12);insert into Test(FillYear,FillMonth,FillDay) values(2013,9,14);insert into Test(FillYear,FillMonth,FillDay) values(2015,10,14);select *,CAST(CAST(FillYear as nvarchar(50))+'-'+CAST(FillMonth as nvarchar(50))+'-'+CAST(FillDay as nvarchar(50)) as datetime) as FillDate from Test;