xt_vd_projectnamelx.txt

ASP程序实现的科技期刊系统

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[XT_VD_ProjectNameLX]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[XT_VD_ProjectNameLX]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE VIEW dbo.XT_VD_ProjectNameLX
AS
SELECT dbo.XT_VD_ProjectName.项目编码, dbo.XT_VD_ProjectName.计划编码, 
      dbo.XT_VD_ProjectName.合并编码, dbo.XT_VD_ProjectName.项目名称, 
      dbo.XT_VD_ProjectName.用户姓名, dbo.XT_VD_ProjectName.申报时间, 
      dbo.XT_VD_ProjectName.年度批次, dbo.XT_VD_ProjectName.项目类别名称, 
      dbo.XT_VD_ProjectName.主持单位, dbo.XT_VD_ProjectName.所在区, 
      dbo.XT_VD_ProjectName.法人代码, dbo.XT_VD_ProjectName.通讯地址, 
      dbo.XT_VD_ProjectName.邮编, dbo.XT_VD_ProjectName.联系人, 
      dbo.XT_VD_ProjectName.联系电话, dbo.XT_VD_ProjectName.电子邮件, 
      dbo.XT_VD_ProjectName.传真, dbo.XT_VD_ProjectName.类别名称, 
      dbo.XT_VD_ProjectName.责任人, dbo.XT_VD_ProjectName.责任处室, 
      dbo.XT_VD_ProjectName.项目进度, dbo.XT_VD_ProjectName.进度状况, 
      dbo.XT_VD_ProjectName.处理意见, dbo.XT_VD_ProjectName.修改标志, 
      dbo.XT_VD_ProjectName.在线评审, dbo.XT_VD_ProjectName.推荐标志, 
      dbo.XT_VD_ProjectName.合同编码, dbo.XT_VD_ProjectName.可行性报告, 
      dbo.XT_VD_ProjectName.注册类型, dbo.XT_VD_ProjectName.企业特性, 
      dbo.XT_VD_ProjectName.项目类别, dbo.XT_VD_ProjectName.项目进度编码, 
      dbo.XT_VD_ProjectName.进度状态编码, dbo.XT_VD_ProjectName.单位类型, 
      dbo.XT_VD_ProjectName.主管部门推荐结果, 
      dbo.XT_VD_ProjectName.主管部门推荐意见, dbo.XT_VD_ProjectName.推荐时间, 
      dbo.XT_VD_ProjectName.推荐部门, dbo.XT_VD_ProjectName.分配接收处室, 
      dbo.XT_VD_ProjectName.项目负责人, dbo.XT_VD_ProjectName.负责人姓名, 
      dbo.XT_VD_ProjectName.技术领域, dbo.XT_VD_ProjectName.项目类别编码, 
      dbo.XT_VD_ProjectName.退回标志, dbo.XT_VD_ProjectName.退回进度, 
      dbo.XT_VD_ProjectName.目标进度, dbo.XT_VD_ProjectName.退回时间, 
      dbo.XT_VD_ProjectName.退回意见, dbo.XT_VD_ProjectName.责任专家, 
      dbo.XT_VD_ProjectName.确认分配, dbo.xt_td_ProjectLX.项目名称 AS 项目名称LX, 
      dbo.xt_td_ProjectLX.主持单位 AS 主持单位LX, 
      dbo.xt_td_ProjectLX.项目类别 AS 项目类别LX, 
      dbo.xt_td_ProjectLX.主要内容 AS 主要内容LX, 
      dbo.xt_td_ProjectLX.预期成果 AS 预期成果LX, 
      dbo.xt_td_ProjectLX.无偿 AS 无偿LX, dbo.xt_td_ProjectLX.贴息 AS 贴息LX, 
      dbo.xt_td_ProjectLX.有偿 AS 有偿LX, dbo.xt_td_ProjectLX.备注 AS 备注LX, 
      dbo.XT_TC_Depart.部门名称
FROM dbo.XT_VD_ProjectName LEFT OUTER JOIN
      dbo.XT_TC_Depart ON 
      dbo.XT_VD_ProjectName.分配接收处室 = dbo.XT_TC_Depart.部门编码 LEFT OUTER JOIN
      dbo.xt_td_ProjectLX ON 
      dbo.XT_VD_ProjectName.项目编码 = dbo.xt_td_ProjectLX.项目编码
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO