我的存储过程里做了个查询是这个德行的
select e.EmployeeId,e.EmployeeName,f1.TheName,f2.TheName,STUFF(STUFF(CONVERT(char(8),e.EntryDate,112),5,0,N'年'),8,0,N'月')+N'日',e.Tele,e.Email select e.EmployeeId,e.Emp
select e.EmployeeId,e.EmployeeName,f1.TheName,f2.TheName,STUFF(STUFF(CONVERT(char(8),e.EntryDate,112),5,0,N'年'),8,0,N'月')+N'日',e.Tele,e.Email select e.EmployeeId,e.Emp