SELECT datename(yy,[ApplyTime]) as 申报年份 ,[EventTypeName]+'--'+[EventName] as 申报项目, [Name] as 姓名,company as 单位,[Mobile] as 手机号,CASE infostatus WHEN 2 THEN '通过' ELSE '未通过' END AS 审核状态
FROM [GjnCompetition2018_Develop].[dbo].[V_DaSai_Apply]
欢迎访问张朋的技术分享社区
共有条评论 网友评论