SQL server语句分析！

来源：百度知道编辑：UC知道时间：2024/06/01 22:34:32

请高手帮我分析一下下面的语句，功能是什么？

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO

----创建视图

alter view Exp_v_Interface as
Select a.DeptID,a.DivID,right(a.AcctCode,datalength(a.AcctCode) - 3) as AcctCode,AcctCode_JJ,
AcctName_JJ = case when substring(AcctCode_JJ,1,1) = '*' then '项目合计' else (select AcctName from Acct_t_AcctItem where AcctCode_JJ = AcctCode) end,
InvestTypeID,a.ProjTypeID,a.ProjectID,Convert(Varchar(8000),b.Content) as Context,Cnum,b.Reserve_1 as DivStatID
from Exp_t_ProjStore a,Exp_t_Project b,Exp_t_ProjectType c,Acct_t_AcctItem d
where a.ProjectID=b.ProjectID
and a.ProjTypeID = c.ProjTypeID
and (AcctCode_JJ not like '*%' or c.ProjType_Type = 1 or a.ProjTypeID in(select DISTINCT ProjTypeID from Exp_t_OutWindowSet WHERE ProjTypeID in(select ProjTypeID from Exp_t_ProjectType where EndFlag=1) and ProjTypeID not in (select distinct ProjTypeID from Exp_t_OutWindowSet wher

看了一下,首先是改变视图Exp_v_Interface,而改变视图里面又有 as
Select ...嵌套语句限制.
之后是简单的表查询,添加数据.

主要是你的那些数据名词太乱了,很难分析.

SET QUOTED_IDENTIFIER OFF
GO
关闭更改行数提示

alter view Exp_v_Interface as
建立虚拟试图的约束

SQL server语句分析！ sql server 建表语句关于sql server中的语句 SQL Server中条件语句 sql server 分组查询语句 SQL server 的语句问题 SQL语句分析关于SQL server 中SQL语句效率 SQL server拆分字段的SQL语句 sql server中的sql语句问题