UNION ALL 视图 不可更新 因为其定义中包含不允许的构造 ##请高手解答
SQL codeCREATE 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