当前位置: 代码迷 >> Sql Server >> UNION ALL 视图 不可更新 由于其定义中包含不允许的构造 #请高手解答
  详细解决方案

UNION ALL 视图 不可更新 由于其定义中包含不允许的构造 #请高手解答

热度:750   发布时间:2016-04-27 11:54:46.0
UNION ALL 视图 不可更新 因为其定义中包含不允许的构造 ##请高手解答
SQL code
CREATE TABLE [SFCDAA08040903] (    [AUDITING] [varchar] (1) COLLATE Chinese_PRC_BIN NOT NULL ,    [COMPANYID] [varchar] (15) COLLATE Chinese_PRC_BIN NULL ,    [CREATEHOST] [varchar] (30) COLLATE Chinese_PRC_BIN NULL ,    [CREATETIME] [varchar] (14) COLLATE Chinese_PRC_BIN NULL ,    [CREATEUSER] [varchar] (10) COLLATE Chinese_PRC_BIN NULL ,    [MODIFYHOST] [varchar] (30) COLLATE Chinese_PRC_BIN NULL ,    [MODIFYTIME] [varchar] (14) COLLATE Chinese_PRC_BIN NULL ,    [MODIFYUSER] [varchar] (10) COLLATE Chinese_PRC_BIN NULL ,    [SIGN] [varchar] (1) COLLATE Chinese_PRC_BIN NOT NULL ,    [CHECKOUT] [varchar] (1) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA001] [varchar] (10) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA002] [varchar] (4) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA003] [varchar] (11) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA004] [varchar] (10) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA005] [varchar] (2) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA006] [varchar] (10) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA007] [varchar] (25) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA008] [varchar] (30) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA009] [varchar] (10) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA010] [varchar] (10) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA011] [varchar] (10) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA012] [varchar] (10) COLLATE Chinese_PRC_BIN NULL ,    [DAA013] [varchar] (10) COLLATE Chinese_PRC_BIN NULL ,    [DAA014] [varchar] (50) COLLATE Chinese_PRC_BIN NULL ,    [DAA015] [varchar] (2) COLLATE Chinese_PRC_BIN NULL ,    [DAA016] [varchar] (20) COLLATE Chinese_PRC_BIN NULL ,    [SECURITYID] [varchar] (36) COLLATE Chinese_PRC_BIN NULL ,    CONSTRAINT [PK_SFCDAA080409031] PRIMARY KEY  CLUSTERED     (        [DAA001],        [DAA002],        [DAA003]    )  ON [EB_shintech_Group] ,    CONSTRAINT [CK_SFCDAA08040903] CHECK ([DAA003] >= '20080400001' and [DAA003] < '20090400001')) ON [EB_shintech_Group]GOCREATE TABLE [SFCDAA09041003] (    [AUDITING] [varchar] (1) COLLATE Chinese_PRC_BIN NOT NULL ,    [COMPANYID] [varchar] (15) COLLATE Chinese_PRC_BIN NULL ,    [CREATEHOST] [varchar] (30) COLLATE Chinese_PRC_BIN NULL ,    [CREATETIME] [varchar] (14) COLLATE Chinese_PRC_BIN NULL ,    [CREATEUSER] [varchar] (10) COLLATE Chinese_PRC_BIN NULL ,    [MODIFYHOST] [varchar] (30) COLLATE Chinese_PRC_BIN NULL ,    [MODIFYTIME] [varchar] (14) COLLATE Chinese_PRC_BIN NULL ,    [MODIFYUSER] [varchar] (10) COLLATE Chinese_PRC_BIN NULL ,    [SIGN] [varchar] (1) COLLATE Chinese_PRC_BIN NOT NULL ,    [CHECKOUT] [varchar] (1) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA001] [varchar] (10) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA002] [varchar] (4) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA003] [varchar] (11) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA004] [varchar] (10) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA005] [varchar] (2) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA006] [varchar] (10) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA007] [varchar] (25) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA008] [varchar] (30) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA009] [varchar] (10) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA010] [varchar] (10) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA011] [varchar] (10) COLLATE Chinese_PRC_BIN NOT NULL ,    [DAA012] [varchar] (10) COLLATE Chinese_PRC_BIN NULL ,    [DAA013] [varchar] (10) COLLATE Chinese_PRC_BIN NULL ,    [DAA014] [varchar] (50) COLLATE Chinese_PRC_BIN NULL ,    [DAA015] [varchar] (2) COLLATE Chinese_PRC_BIN NULL ,    [DAA016] [varchar] (20) COLLATE Chinese_PRC_BIN NULL ,    [SECURITYID] [varchar] (36) COLLATE Chinese_PRC_BIN NULL ,    CONSTRAINT [PK_SFCDAA090410031] PRIMARY KEY  CLUSTERED     (        [DAA001],        [DAA002],        [DAA003]    )  ON [EB_shintech_Group] ,    CONSTRAINT [CK_SFCDAA09041003] CHECK ([DAA003] >= '20090400001' and [DAA003] < '20100400001')) ON [EB_shintech_Group]GO