?? xt_vd_projectnamelx.txt
字號:
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
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -