UNION ALL 视图 不可更新 由于其定义中包含不允许的构造 #请高手解答
日期：2014-05-18 浏览次数：20562 次
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
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
