用于搜刮具有无穷数目的位字段的表的SQL计划要领
发布时间：2021-04-01 00:19:04 所属栏目：编程 来源：网络整理
导读：思量搜刮包括公寓租赁信息的表：行使该界面的客户端选择在数据库中暗示为位字段的多个前提,譬喻： AllowPets HasParking HasDeck ModernKitchen 等等.. 我们面对的环境是,我们软件的每个新客户都有他们但愿应承最终用户搜刮的其他字段.位字段的数目可以到达数
|
插入样本数据： SET NO COUNT ON
INSERT INTO #Apartments VALUES ('one','A')
INSERT INTO #Apartments VALUES ('two','A')
INSERT INTO #Apartments VALUES ('three','I')
INSERT INTO #Apartments VALUES ('four','I')
INSERT INTO #AttributeTypes VALUES (1,'dishwasher')
INSERT INTO #AttributeTypes VALUES (2,'deck')
INSERT INTO #AttributeTypes VALUES (3,'pool')
INSERT INTO #AttributeTypes VALUES (4,'pets allowed')
INSERT INTO #AttributeTypes VALUES (5,'washer/dryer')
INSERT INTO #AttributeTypes VALUES (6,'Pets Alowed')
INSERT INTO #AttributeTypes VALUES (7,'No Pets')
INSERT INTO #Attributes (ApartmentID,AttributeType) VALUES (1,1)
INSERT INTO #Attributes (ApartmentID,2)
INSERT INTO #Attributes (ApartmentID,3)
INSERT INTO #Attributes (ApartmentID,4)
INSERT INTO #Attributes (ApartmentID,5)
INSERT INTO #Attributes (ApartmentID,6)
INSERT INTO #Attributes (ApartmentID,AttributeType) VALUES (2,7)
INSERT INTO #Attributes (ApartmentID,AttributeType) VALUES (3,4)
INSERT INTO #Attributes (ApartmentID,AttributeType) VALUES (4,2)
SET NOCOUNT OFF
（编辑：湖南网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
