CREATE TABLE [dbo].[A](
[id] [bigint] IDENTITY (1,1) NOT NULL,
[档案编号] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL,
) ON [PRIMARY]
CREATE TABLE [dbo].[B](
[id] [bigint] IDENTITY (1,1) NOT NULL,
[档案编号] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL,
[家庭成员编号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
) ON [PRIMARY]
CREATE TABLE [dbo].[C](
[id] [bigint] IDENTITY (1,1) NOT NULL,
[档案编号] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL,
[家庭成员编号] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[D](
[id] [bigint] IDENTITY (1,1) NOT NULL,
[区县名] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL,
[乡镇名] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL,
[村社名] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL,
[组街道名] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL,
[档案编号] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL,
[高程] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL,
[权属人] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL,
[权属人身份证号] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL,
[淹没线范围内大荔枝] [numeric](5,0) Default 0,
[淹没线范围内特大荔枝] [numeric](5,0) Default 0,
[淹没线范围内一般荔枝] [numeric](5,0) Default 0,
[淹没线范围内大桂圆] [numeric](5,0) Default 0,
[淹没线范围内特大桂圆] [numeric](5,0) Default 0,
[淹没线范围内一般桂圆] [numeric](5,0) Default 0,
[淹没线范围内大核桃] [numeric](5,0) Default 0,
[淹没线范围内一般核桃] [numeric](5,0) Default 0,
[淹没线范围内大葡萄] [numeric](5,0) Default 0,
[淹没线范围内一般葡萄] [numeric](5,0) Default 0,
[淹没线范围内大石榴] [numeric](5,0) Default 0,
[淹没线范围内一般石榴] [numeric](5,0) Default 0,
[淹没线范围内大砂仁] [numeric](5,0) Default 0,
[淹没线范围内一般砂仁] [numeric](5,0) Default 0,
[淹没线范围内大板栗] [numeric](5,0) Default 0,
[淹没线范围内一般板栗] [numeric](5,0) Default 0,
[淹没线范围内大枇杷] [numeric](5,0) Default 0,
[淹没线范围内一般枇杷] [numeric](5,0) Default 0,
[淹没线范围内大花椒] [numeric](5,0) Default 0,
[淹没线范围内一般花椒] [numeric](5,0) Default 0,
[淹没线范围内大樟树] [numeric](5,0) Default 0,
[淹没线范围内一般樟树] [numeric](5,0) Default 0,
[淹没线范围内大杂树] [numeric](5,0) Default 0,
[淹没线范围内大茶树] [numeric](5,0) Default 0,
[淹没线范围内一般茶树] [numeric](5,0) Default 0,
[淹没线范围内大脐橙] [numeric](5,0) Default 0,
[淹没线范围内一般脐橙] [numeric](5,0) Default 0,
[淹没线范围内大枣] [numeric](5,0) Default 0,
[淹没线范围内一般枣] [numeric](5,0) Default 0,
[淹没线范围内大椪柑] [numeric](5,0) Default 0,
[淹没线范围内一般椪柑] [numeric](5,0) Default 0,
[淹没线范围内大柚子] [numeric](5,0) Default 0,
[淹没线范围内一般柚子] [numeric](5,0) Default 0,
[淹没线范围内大柑桔] [numeric](5,0) Default 0,
[淹没线范围内一般柑桔] [numeric](5,0) Default 0,
[淹没线范围内大桃] [numeric](5,0) Default 0,
[淹没线范围内大李] [numeric](5,0) Default 0,
[淹没线范围内一般李] [numeric](5,0) Default 0,
[淹没线范围内大梨] [numeric](5,0) Default 0,
[淹没线范围内一般梨] [numeric](5,0) Default 0,
[淹没线范围内大杏] [numeric](5,0) Default 0,
[淹没线范围内一般杏] [numeric](5,0) Default 0,
[淹没线范围内大樱桃] [numeric](5,0) Default 0,
[淹没线范围内一般樱桃] [numeric](5,0) Default 0,
[淹没线范围内大柿子] [numeric](5,0) Default 0,
[淹没线范围内一般柿子] [numeric](5,0) Default 0,
[淹没线范围内一般香蕉] [numeric](5,0) Default 0,
[淹没线范围内大竹子] [numeric](5,0) Default 0,
[淹没线范围内一般竹子] [numeric](5,0) Default 0,
[淹没线范围内大蚕桑] [numeric](5,0) Default 0,
[淹没线范围内一般蚕桑] [numeric](5,0) Default 0,
[淹没线范围内大桐棬] [numeric](5,0) Default 0,
[淹没线范围内一般桐棬] [numeric](5,0) Default 0,
[淹没线范围内大名木古树] [numeric](5,0) Default 0,
[淹没线范围内一般名木古树] [numeric](5,0) Default 0,
[淹没线范围内大杜仲] [numeric](5,0) Default 0,
[淹没线范围内一般杜仲] [numeric](5,0) Default 0,
[淹没线范围内大其它] [numeric](5,0) Default 0,
[淹没线范围内一般其它] [numeric](5,0) Default 0,
[淹没线范围外大荔枝] [numeric](5,0) Default 0,
[淹没线范围外特大荔枝] [numeric](5,0) Default 0,
[淹没线范围外一般荔枝] [numeric](5,0) Default 0,
[淹没线范围外大桂圆] [numeric](5,0) Default 0,
[淹没线范围外特大桂圆] [numeric](5,0) Default 0,
[淹没线范围外一般桂圆] [numeric](5,0) Default 0,
[淹没线范围外大核桃] [numeric](5,0) Default 0,
[淹没线范围外一般核桃] [numeric](5,0) Default 0,
[淹没线范围外大葡萄] [numeric](5,0) Default 0,
[淹没线范围外一般葡萄] [numeric](5,0) Default 0,
[淹没线范围外大石榴] [numeric](5,0) Default 0,
[淹没线范围外一般石榴] [numeric](5,0) Default 0,
[淹没线范围外大砂仁] [numeric](5,0) Default 0,
[淹没线范围外一般砂仁] [numeric](5,0) Default 0,
[淹没线范围外大板栗] [numeric](5,0) Default 0,
[淹没线范围外一般板栗] [numeric](5,0) Default 0,
[淹没线范围外大枇杷] [numeric](5,0) Default 0,
[淹没线范围外一般枇杷] [numeric](5,0) Default 0,
[淹没线范围外大花椒] [numeric](5,0) Default 0,
[淹没线范围外一般花椒] [numeric](5,0) Default 0,
[淹没线范围外大樟树] [numeric](5,0) Default 0,
[淹没线范围外一般樟树] [numeric](5,0) Default 0,
[淹没线范围外大杂树] [numeric](5,0) Default 0,
[淹没线范围外一般杂树] [numeric](5,0) Default 0,
[淹没线范围外大茶树] [numeric](5,0) Default 0,
[淹没线范围外一般茶树] [numeric](5,0) Default 0,
[淹没线范围外大脐橙] [numeric](5,0) Default 0,
[淹没线范围外一般脐橙] [numeric](5,0) Default 0,
[淹没线范围外大枣] [numeric](5,0) Default 0,
[淹没线范围外一般枣] [numeric](5,0) Default 0,
[淹没线范围外大椪柑] [numeric](5,0) Default 0,
[淹没线范围外一般椪柑] [numeric](5,0) Default 0,
[淹没线范围外大柚子] [numeric](5,0) Default 0,
[淹没线范围外一般柚子] [numeric](5,0) Default 0,
[淹没线范围外大柑桔] [numeric](5,0) Default 0,
[淹没线范围外一般柑桔] [numeric](5,0) Default 0,
[淹没线范围外大桃] [numeric](5,0) Default 0,
[淹没线范围外一般桃] [numeric](5,0) Default 0,
[淹没线范围外大李] [numeric](5,0) Default 0,
[淹没线范围外一般李] [numeric](5,0) Default 0,
[淹没线范围外大梨] [numeric](5,0) Default 0,
[淹没线范围外一般梨] [numeric](5,0) Default 0,
[淹没线范围外大杏] [numeric](5,0) Default 0,
[淹没线范围外一般杏] [numeric](5,0) Default 0,
[淹没线范围外大樱桃] [numeric](5,0) Default 0,
[淹没线范围外一般樱桃] [numeric](5,0) Default 0,
[淹没线范围外大柿子] [numeric](5,0) Default 0,
[淹没线范围外一般柿子] [numeric](5,0) Default 0,
[淹没线范围外大香蕉] [numeric](5,0) Default 0,
[淹没线范围外一般香蕉] [numeric](5,0) Default 0,
[淹没线范围外大竹子] [numeric](5,0) Default 0,
[淹没线范围外大蚕桑] [numeric](5,0) Default 0,
[淹没线范围外一般蚕桑] [numeric](5,0) Default 0,
[淹没线范围外大桐棬] [numeric](5,0) Default 0,
[淹没线范围外一般桐棬] [numeric](5,0) Default 0,
[淹没线范围外大名木古树] [numeric](5,0) Default 0,
[淹没线范围外一般名木古树] [numeric](5,0) Default 0,
[淹没线范围外大杜仲] [numeric](5,0) Default 0,
[淹没线范围外一般杜仲] [numeric](5,0) Default 0,
[淹没线范围外大其它] [numeric](5,0) Default 0,
[淹没线范围外一般其它] [numeric](5,0) Default 0,
[围堰水位上] [numeric](5,0) Default 0,
[围堰水位下] [numeric](5,0) Default 0,
[影响区] [numeric](5,0) Default 0,
[城集镇新址区] [numeric](5,0) Default 0,
[淹没范围] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL,
[淹没线范围内大苦竹] [numeric](5,0) Default 0,
[淹没线范围外大苦竹] [numeric](5,0) Default 0,
[淹没线范围内一般苦竹] [numeric](5,0) Default 0,
[淹没线范围外一般苦竹] [numeric](5,0) Default0,
[淹没线范围内一般杂树] [numeric](5,0) Default0,
[淹没线范围内一般桃] [numeric](5,0) Default0,
[淹没线范围内大香蕉] [numeric](5,0) Default0,
[淹没线范围外一般竹子] [numeric](5,0) Default0,
[库区] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL,
[零星果木编号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[流水编号] [varchar] (30) COLLATE Chinese_PRC_CI_ASNULL,
[移民专业] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL,
[家庭成员编号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
A的档案编号和B,B的家庭成员编号和C,D。B和C都能建立,B和D建立就有错。把D表的列删除一部分,就可以了,是不是D表的列太多了的原因的?
[id] [bigint] IDENTITY (1,1) NOT NULL,
[档案编号] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL,
) ON [PRIMARY]
CREATE TABLE [dbo].[B](
[id] [bigint] IDENTITY (1,1) NOT NULL,
[档案编号] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL,
[家庭成员编号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
) ON [PRIMARY]
CREATE TABLE [dbo].[C](
[id] [bigint] IDENTITY (1,1) NOT NULL,
[档案编号] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL,
[家庭成员编号] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[D](
[id] [bigint] IDENTITY (1,1) NOT NULL,
[区县名] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL,
[乡镇名] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL,
[村社名] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL,
[组街道名] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL,
[档案编号] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL,
[高程] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL,
[权属人] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL,
[权属人身份证号] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL,
[淹没线范围内大荔枝] [numeric](5,0) Default 0,
[淹没线范围内特大荔枝] [numeric](5,0) Default 0,
[淹没线范围内一般荔枝] [numeric](5,0) Default 0,
[淹没线范围内大桂圆] [numeric](5,0) Default 0,
[淹没线范围内特大桂圆] [numeric](5,0) Default 0,
[淹没线范围内一般桂圆] [numeric](5,0) Default 0,
[淹没线范围内大核桃] [numeric](5,0) Default 0,
[淹没线范围内一般核桃] [numeric](5,0) Default 0,
[淹没线范围内大葡萄] [numeric](5,0) Default 0,
[淹没线范围内一般葡萄] [numeric](5,0) Default 0,
[淹没线范围内大石榴] [numeric](5,0) Default 0,
[淹没线范围内一般石榴] [numeric](5,0) Default 0,
[淹没线范围内大砂仁] [numeric](5,0) Default 0,
[淹没线范围内一般砂仁] [numeric](5,0) Default 0,
[淹没线范围内大板栗] [numeric](5,0) Default 0,
[淹没线范围内一般板栗] [numeric](5,0) Default 0,
[淹没线范围内大枇杷] [numeric](5,0) Default 0,
[淹没线范围内一般枇杷] [numeric](5,0) Default 0,
[淹没线范围内大花椒] [numeric](5,0) Default 0,
[淹没线范围内一般花椒] [numeric](5,0) Default 0,
[淹没线范围内大樟树] [numeric](5,0) Default 0,
[淹没线范围内一般樟树] [numeric](5,0) Default 0,
[淹没线范围内大杂树] [numeric](5,0) Default 0,
[淹没线范围内大茶树] [numeric](5,0) Default 0,
[淹没线范围内一般茶树] [numeric](5,0) Default 0,
[淹没线范围内大脐橙] [numeric](5,0) Default 0,
[淹没线范围内一般脐橙] [numeric](5,0) Default 0,
[淹没线范围内大枣] [numeric](5,0) Default 0,
[淹没线范围内一般枣] [numeric](5,0) Default 0,
[淹没线范围内大椪柑] [numeric](5,0) Default 0,
[淹没线范围内一般椪柑] [numeric](5,0) Default 0,
[淹没线范围内大柚子] [numeric](5,0) Default 0,
[淹没线范围内一般柚子] [numeric](5,0) Default 0,
[淹没线范围内大柑桔] [numeric](5,0) Default 0,
[淹没线范围内一般柑桔] [numeric](5,0) Default 0,
[淹没线范围内大桃] [numeric](5,0) Default 0,
[淹没线范围内大李] [numeric](5,0) Default 0,
[淹没线范围内一般李] [numeric](5,0) Default 0,
[淹没线范围内大梨] [numeric](5,0) Default 0,
[淹没线范围内一般梨] [numeric](5,0) Default 0,
[淹没线范围内大杏] [numeric](5,0) Default 0,
[淹没线范围内一般杏] [numeric](5,0) Default 0,
[淹没线范围内大樱桃] [numeric](5,0) Default 0,
[淹没线范围内一般樱桃] [numeric](5,0) Default 0,
[淹没线范围内大柿子] [numeric](5,0) Default 0,
[淹没线范围内一般柿子] [numeric](5,0) Default 0,
[淹没线范围内一般香蕉] [numeric](5,0) Default 0,
[淹没线范围内大竹子] [numeric](5,0) Default 0,
[淹没线范围内一般竹子] [numeric](5,0) Default 0,
[淹没线范围内大蚕桑] [numeric](5,0) Default 0,
[淹没线范围内一般蚕桑] [numeric](5,0) Default 0,
[淹没线范围内大桐棬] [numeric](5,0) Default 0,
[淹没线范围内一般桐棬] [numeric](5,0) Default 0,
[淹没线范围内大名木古树] [numeric](5,0) Default 0,
[淹没线范围内一般名木古树] [numeric](5,0) Default 0,
[淹没线范围内大杜仲] [numeric](5,0) Default 0,
[淹没线范围内一般杜仲] [numeric](5,0) Default 0,
[淹没线范围内大其它] [numeric](5,0) Default 0,
[淹没线范围内一般其它] [numeric](5,0) Default 0,
[淹没线范围外大荔枝] [numeric](5,0) Default 0,
[淹没线范围外特大荔枝] [numeric](5,0) Default 0,
[淹没线范围外一般荔枝] [numeric](5,0) Default 0,
[淹没线范围外大桂圆] [numeric](5,0) Default 0,
[淹没线范围外特大桂圆] [numeric](5,0) Default 0,
[淹没线范围外一般桂圆] [numeric](5,0) Default 0,
[淹没线范围外大核桃] [numeric](5,0) Default 0,
[淹没线范围外一般核桃] [numeric](5,0) Default 0,
[淹没线范围外大葡萄] [numeric](5,0) Default 0,
[淹没线范围外一般葡萄] [numeric](5,0) Default 0,
[淹没线范围外大石榴] [numeric](5,0) Default 0,
[淹没线范围外一般石榴] [numeric](5,0) Default 0,
[淹没线范围外大砂仁] [numeric](5,0) Default 0,
[淹没线范围外一般砂仁] [numeric](5,0) Default 0,
[淹没线范围外大板栗] [numeric](5,0) Default 0,
[淹没线范围外一般板栗] [numeric](5,0) Default 0,
[淹没线范围外大枇杷] [numeric](5,0) Default 0,
[淹没线范围外一般枇杷] [numeric](5,0) Default 0,
[淹没线范围外大花椒] [numeric](5,0) Default 0,
[淹没线范围外一般花椒] [numeric](5,0) Default 0,
[淹没线范围外大樟树] [numeric](5,0) Default 0,
[淹没线范围外一般樟树] [numeric](5,0) Default 0,
[淹没线范围外大杂树] [numeric](5,0) Default 0,
[淹没线范围外一般杂树] [numeric](5,0) Default 0,
[淹没线范围外大茶树] [numeric](5,0) Default 0,
[淹没线范围外一般茶树] [numeric](5,0) Default 0,
[淹没线范围外大脐橙] [numeric](5,0) Default 0,
[淹没线范围外一般脐橙] [numeric](5,0) Default 0,
[淹没线范围外大枣] [numeric](5,0) Default 0,
[淹没线范围外一般枣] [numeric](5,0) Default 0,
[淹没线范围外大椪柑] [numeric](5,0) Default 0,
[淹没线范围外一般椪柑] [numeric](5,0) Default 0,
[淹没线范围外大柚子] [numeric](5,0) Default 0,
[淹没线范围外一般柚子] [numeric](5,0) Default 0,
[淹没线范围外大柑桔] [numeric](5,0) Default 0,
[淹没线范围外一般柑桔] [numeric](5,0) Default 0,
[淹没线范围外大桃] [numeric](5,0) Default 0,
[淹没线范围外一般桃] [numeric](5,0) Default 0,
[淹没线范围外大李] [numeric](5,0) Default 0,
[淹没线范围外一般李] [numeric](5,0) Default 0,
[淹没线范围外大梨] [numeric](5,0) Default 0,
[淹没线范围外一般梨] [numeric](5,0) Default 0,
[淹没线范围外大杏] [numeric](5,0) Default 0,
[淹没线范围外一般杏] [numeric](5,0) Default 0,
[淹没线范围外大樱桃] [numeric](5,0) Default 0,
[淹没线范围外一般樱桃] [numeric](5,0) Default 0,
[淹没线范围外大柿子] [numeric](5,0) Default 0,
[淹没线范围外一般柿子] [numeric](5,0) Default 0,
[淹没线范围外大香蕉] [numeric](5,0) Default 0,
[淹没线范围外一般香蕉] [numeric](5,0) Default 0,
[淹没线范围外大竹子] [numeric](5,0) Default 0,
[淹没线范围外大蚕桑] [numeric](5,0) Default 0,
[淹没线范围外一般蚕桑] [numeric](5,0) Default 0,
[淹没线范围外大桐棬] [numeric](5,0) Default 0,
[淹没线范围外一般桐棬] [numeric](5,0) Default 0,
[淹没线范围外大名木古树] [numeric](5,0) Default 0,
[淹没线范围外一般名木古树] [numeric](5,0) Default 0,
[淹没线范围外大杜仲] [numeric](5,0) Default 0,
[淹没线范围外一般杜仲] [numeric](5,0) Default 0,
[淹没线范围外大其它] [numeric](5,0) Default 0,
[淹没线范围外一般其它] [numeric](5,0) Default 0,
[围堰水位上] [numeric](5,0) Default 0,
[围堰水位下] [numeric](5,0) Default 0,
[影响区] [numeric](5,0) Default 0,
[城集镇新址区] [numeric](5,0) Default 0,
[淹没范围] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL,
[淹没线范围内大苦竹] [numeric](5,0) Default 0,
[淹没线范围外大苦竹] [numeric](5,0) Default 0,
[淹没线范围内一般苦竹] [numeric](5,0) Default 0,
[淹没线范围外一般苦竹] [numeric](5,0) Default0,
[淹没线范围内一般杂树] [numeric](5,0) Default0,
[淹没线范围内一般桃] [numeric](5,0) Default0,
[淹没线范围内大香蕉] [numeric](5,0) Default0,
[淹没线范围外一般竹子] [numeric](5,0) Default0,
[库区] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL,
[零星果木编号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[流水编号] [varchar] (30) COLLATE Chinese_PRC_CI_ASNULL,
[移民专业] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL,
[家庭成员编号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
A的档案编号和B,B的家庭成员编号和C,D。B和C都能建立,B和D建立就有错。把D表的列删除一部分,就可以了,是不是D表的列太多了的原因的?
解决方案 »
- 怎样使查询的结果就是一个字符串 SqlServer2005
- sql server 2005 对去掉干扰词后某些词仍无法搜索
- 有谁下载了微软网站TechNet“SQL Server 2005盛宴系列”的视频?怎么下载不了?
- 将一条记录分成十几条记录后,可是金额,税额,价税合计如何保证合计值与原先的计算平衡呢?
- 请问谁有MS SQL 存储过程和内建函数的语法规则
- 一个SQL server的题目
- 数据拷贝问题
- 我把SQL数据库移植成access数据库后,触发器该如何移植?
- 备份数据库恢复的问题
- select返回一个记录集,这个记录集存放在服务器临时数据库中,还是直接返回客户端的应用程序中??
- 用SQL语句是否可实现在整个数据中查找某个字符串?
- 数据库查询统计的问题
那么多品種,其實只要2個欄位
比如
數量 品種
-----------------------------
100 淹没线范围外大香蕉
200 淹没线范围外一般香蕉
而不必
淹没线范围外大香蕉 淹没线范围外一般香蕉
----------------------------------------
100 200
否則萬一以后添品種,大西瓜,大冬瓜的,啟不要修改table 結構了
1,大香蕉
2,一般香蕉 -----用一个关联表:
d表[id] ,品种表ID
[淹没线范围内大桃] [numeric](5,0) Default 0, 难道没有下面这个?
[淹没线范围内一般大桃] [numeric](5,0) Default 0, 这个表D,如果真的有数据进去了,用户再让你加个"一般大桃",就有你忙的了。