日期:2014-05-18  浏览次数:20604 次

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]
GO

CREATE 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